Access issue in mysql through sqoop

sqoop

#1

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://nn01.itversity.com:3306/retail_db” --username retail_dba --password itversity --qu
ery “select count(*) from orders”;


#2

@sudarsan

There is no database named retial_db. It is retail_db.


#3

@sudarsan

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://nn01.itversity.com:3306/retail_db” --username retail_dba --password itversity --query “select count(*) from orders”;


#4

Thanks .Its working fine. Appreciate your help.


#5

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


#6