Access Denied for Access Database when using built job

[ghensan]

Hello everyone, i have a pickle here when using talend data integration

i use Talend 7.3.1 and MySQL 8

when i built the Job and run it on server via Jenkins, it always said

Exception in component tDBOutput_3 (********)

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

the funny thing is, i of course try it first on my local machine

test connection always return OK, and also when i test run it, it always work just fine, and it also write and read from DB just fine

it just Error when i try to run the built Job

anyone have clue why and how to fix it ?

[JohnRMK]

Hello,

I believe it is an SSL or TLS issue. I am not sure of the exact terms but it is related to security. Otherwise it can come from user rights. If in Jenkins you use the user windows known from the DBMS and in talend you use a named user. You can search in stackoverflow, I have already seen this error

[Anonymous]

Hi

Go to check if your Mysql server allows remote access.

Regards

Shong