Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

unable to connect to mysql databases through sqoop

New Contributor
I am running below command to connect and display mysql databases through sqoop 

sqoop list-databases \ > --connect jdbc:mysql://quickstart.cloudera:3306/retail_db \ > --username retail_dba \ > --password cloudera \

it is showing following error:
Error Tool.BaseSqoopTool:Error parsing arguments fro list-databses:
Error Tool.BaseSqoopTool:Unreognized arguments:retial_dba --password
Error Tool.baseSqoopTool:Unrecognized arguments:cloudera

Please help me to get out of it


3 REPLIES 3

New Contributor
sqoop list-databases \
>   --connect jdbc:mysql://quickstart.cloudera:3306/retail_db \
>   --username retail_dba \
>   --password cloudera \

there is no retail_dba user , replace this with root 

 update above code as follows :

sqoop list-databases 
>   --connect jdbc:mysql://quickstart.cloudera:3306/retail_db 
>   --username root
>   --password cloudera 

It works now .

Champion

I am sure you can try the username as Cloudera as well

New Contributor
sqoop-list-databases \
>   --connect "jdbc:mysql://quickstart.cloudera:3306/retail_db" \
>   --username retail_dba \
>   --password cloudera \
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.