Access denied error for sqoop import


#1

hai,

I am getting access denied error for ‘sqoopuser’

the command I gave is

sqoop import --connect ‘jdbc:mysql://ip-172-31-20-247:3306/retail_db’ --table categories --username sqoopuser -P

I am getting the below error

18/09/18 06:24:15 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Access denied for user ‘sqoopuser’@‘ip-172-31-38-146.ec2
.internal’ (using password: YES)
java.sql.SQLException: Access denied for user ‘sqoopuser’@‘ip-172-31-38-146.ec2.internal’ (using password: YES)


#2

Hi @atsbhalab01,

Please use the correct MySQL password specified under “My Lab” and it should work. Its working fine for me and others.