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.

1%20sqoop%20issue
1 sqoop issue.JPG1447×271 82.7 KB

#3

Hi Ram,

Thanks for rectifying my command. It worked now.

Regards,
Gowtham.