Reply
Suj
New Contributor
Posts: 3
Registered: ‎11-20-2018

unable to connect to mysql databases through sqoop

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


Suj
New Contributor
Posts: 3
Registered: ‎11-20-2018

Re: unable to connect to mysql databases through sqoop

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
Champion
Posts: 753
Registered: ‎05-16-2016

Re: unable to connect to mysql databases through sqoop

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

Announcements