SQL exception executing statement

#1

Getting the following error while connecting from sqoop
21/05/20 03:34:42 WARN tool.EvalSqlTool: SQL exception executing statement: java.sql.SQLException: Access denied for user ‘sqoop
user’@‘cxln4.c.thelab-240901.internal’ (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)

#2

Could you please share a screenshot of how you are trying to connect, please ensure that the screenshot contains your command and the error it is throwing. Thanks.

#3

image
image1887×728 136 KB

#4

Please view attached screenshot

#5

Thank you for the screenshot. Please don’t mind me asking but what are you trying to do here? Are you following any of the hands-on materials given in our courses?

#6

Hi Randhir,

The password of sqoopuser seems to be wrong. Please check https://cloudxlab.com/my-lab#mysql-credentials

The password starts with “NH” not “pNH”

1 Like
#7

Thanks a lot, I never thought that this will the issue, It’s working now.
Please keep a space in the MYSQL connection, This can be an issue to everyone -pNHkkP876rp

1 Like