Sqoop mysql connection issues,


#1

I have tried as suggested but getting below error.

[anidaki84@gw02 ~]$ sqoop list-databases --connect jdbc:mysql://msitversity.com:3306 --username retail_user --password itversity
19/01/17 11:13:14 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.6.5.0-292
19/01/17 11:13:14 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
19/01/17 11:13:14 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
19/01/17 11:13:14 ERROR manager.CatalogQueryManager: Failed to list databases
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.


#2

You are missing dot in between ms and itversity

–connect jdbc:mysql://ms.itversity.com:3306


#3

Thank you., it worked.


#4