Support Questions
Find answers, ask questions, and share your expertise

unable to connect to mysql databases through sqoop

Highlighted

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


2 REPLIES 2
Highlighted

Re: unable to connect to mysql databases through sqoop

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 .
Highlighted

Re: unable to connect to mysql databases through sqoop

Champion

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

Don't have an account?