Talend to MySQL connection error

RMukherjee08 · ‎2022-05-20

Hi,

I am getting the error as per below while running the talend job to load data in MySQL cloud instance.

I have the access to the MySQL DB (can connect to the server from MySQL application with SSL certificates enabled)

error:

Starting job dummy_01 at 17:18 20/05/2022.

[statistics] connecting to socket on port 3697

[statistics] connected

Exception in component tDBOutput_1

java.sql.SQLException: Access denied for user 'user_name'@'server_IP' (using password: YES)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)

at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)

at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)

at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)

at java.sql.DriverManager.getConnection(Unknown Source)

at drl_rover.dummy.dummy_01.tBigQueryInput_1Process(dummy_01.java:952)

at drl_rover.dummy.dummy_01.runJobInTOS(dummy_01.java:2111)

at drl_rover.dummy.dummy_01.main(dummy_01.java:1890)

[statistics] disconnected

Job dummy_01 ended at 17:18 20/05/2022. [Exit code = 1]

please help me to resolve the issue

TCalabro1652773885 · ‎2022-05-23

Looking for a close to issue. Expecting a reply.

Anonymous · ‎2022-05-23

Hello,

We have already replied to this thread:

Could you please have a look at it.

Best regards

Sabrina

Related Topics