Sqoop Import Permission Denied

#1

Hi using follwoing sqoop command and saying permission denied

sqoop import \

–connect jdbc:mysql://nn01.itversity.com:3306/retail_export
–username retail_user
–password itversity
–table orders
–target-dir /user/hareeshbachakoora/sqoop_import/retail_db/Arun_import
–delete-target-dir
–num-mappers 1

Access denied for user ‘retail_user’@‘gw03.itversity.com’ (using password: YES)
java.sql.SQLException: Access denied for user ‘retail_user’@‘gw03.itversity.com’ (using password: YES)

0 Likes

#2

use “ms.itversity.com:3306” instead of “nn01.itversity.com:3306

0 Likes

#3

THanks for reply, ihave tried both bit facing same issue

0 Likes

#4

Sorry, its working, thanks a lot

0 Likes

closed #5
0 Likes