Access denied Error in SQOOP

Technical Discussions Sqoop
#1

Hi,
I’m getting access denied error while using SQOOP command.

command:sqoop list-databases --connect “jdbc:mysql://ip-172-31-20-247:3306” --username scoopuser -P

18/09/18 06:38:25 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: java.sql.SQLException: Access denied for user 'scoopuser
'@‘ip-172-31-38-146.ec2.internal’ (using password: YES)
java.lang.RuntimeException: java.sql.SQLException: Access denied for user ‘scoopuser’@‘ip-172-31-38-146.ec2.internal’ (using password: YES)

#2

Hi @atsbhlab02,

username is sqoopuser not scoopuser.