Talend to MySQL connection error

RMukherjee08 — Fri, 15 Nov 2024 22:54:24 GMT

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

Re: Talend to MySQL connection error

TCalabro1652773885 — Mon, 23 May 2022 06:15:54 GMT

Looking for a close to issue. Expecting a reply.

Anonymous — Mon, 23 May 2022 08:15:49 GMT

Hello,

We have already replied to this thread:

Could you please have a look at it.

Best regards

Sabrina