Access issue in mysql through sqoop



I am trying to use sqoop to access mysql but its hows access denied for “retial_db” for the username retail_dba and pwd - itversity /but i can able to access mysql shell to view the tables .

sqoop eval --connect “jdbc:mysql://” --username retail_dba --password itversity --qu
ery “select count(*) from orders”;



There is no database named retial_db. It is retail_db.



Hi, your query is working fine but u pasted the query in the 3 lines so use the below query and try again it will work.

sqoop eval --connect “jdbc:mysql://” --username retail_dba --password itversity --query “select count(*) from orders”;


Thanks .Its working fine. Appreciate your help.


My syntax is working fine with 3 line issue is database name spelled incorrectly. Appreciate your time to over look it.