Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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 .

Re: unable to connect to mysql databases through sqoop

Champion

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