Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

user access denied error in mysql connection

Hi

I'm facing very bad situation in Mysql 5.7
I'm having username--> pop and password --> pop with database name "Home"
When I connect from workbench..its works fine.
When I connect through tmysqlinputconnection (adding manually credentials in component) it works.
Problem is, when I try to connect the tmysqlinputconnection  with conext parameters where values are coming from file
Shows error like this-----> Access denied for user 'pop'@'localhost' (using password: YES)
May I know please from where its coming ...?
Thanks in advance !!

Labels (2)
10 Replies
jay6
Contributor III
Contributor III

The only component in my job right now is tMyssqlConnection. No sense me completing the whole job not knowing it's going to work. Would be wasting my time.
For security reasons I've removed the user name and password in the error message.

Here is the error message. This is a remote connection to a remote DB on a different domain. I've also pasted a snapshot of the settings.
Starting job BSD_Test at 09:48 20/02/2017.

[statistics] connecting to socket on port 4050
[statistics] connected
Exception in component tMysqlConnection_1
java.sql.SQLException: Access denied for user 'user name and IP Address here' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:926)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1748)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1288)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2506)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2539)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2321)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[FATAL]: local.bsd_test_0_1.BSD_Test - tMysqlConnection_1 Access denied for user 'User name and IP Address' (using password: YES)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at local.bsd_test_0_1.BSD_Test.tMysqlConnection_1Process(BSD_Test.java:429)
at local.bsd_test_0_1.BSD_Test.runJobInTOS(BSD_Test.java:758)
at local.bsd_test_0_1.BSD_Test.main(BSD_Test.java:561)
2567 milliseconds
[statistics] disconnected
Job BSD_Test ended at 09:48 20/02/2017. [exit code=1]
0683p000009MFMn.png