Not able get database list using sqoop from mysql


#1

Dear Team,

I executed followed command. But not able to retrieve database lists from mysql using sqoop.

sqoop list-databases --connect “jdbc:mysql://cxln1.c.thelab-240901.internal:8020” --username sqoopuser -P

Please check the command and provide me with correct command.

Thanks & Regards,
Gowtham.


#2

I think you are giving wrong port no. I have used 3306 which is working for me.
Use the command as shown below:
sqoop list-databases --connect "jdbc:mysql://<Host>:3306" --username <User> -P

You can get host,user & password details from this page.


#3

Hi Ram,

Thanks for rectifying my command. It worked now.

Regards,
Gowtham.