Connection String for MySQL database using Sqoop

Question

Hi. Can someone tell me what is the connection string used to access the MySQL database from Sqoop?

Answer 1

The format for the connection string and the example is as follows:

Format:

jdbc:mysql://<HOST>:<PORT>/<DATABASE_NAME>

Example:

jdbc:mysql://my_mysql_server_hostname:3306/my_database_name