Connection Failure: Talend 6.5 to MySQL 8.0

Five Stars HA
Five Stars

Connection Failure: Talend 6.5 to MySQL 8.0

Hi,

 

I am having issues connecting to MySQL server 8.0 from Talend 6.5.

MySQL.PNG

 

Any idea how to resolve this?

Thanks

Twelve Stars

Re: Connection Failure: Talend 6.5 to MySQL 8.0

unless all JDBC and other software not switch to native support new MySQL authentication 

You must enable on MySQL support old clients - https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-pas...

plus You must create user with old password format

 

-----------
Four Stars

Re: Connection Failure: Talend 6.5 to MySQL 8.0

Hi HA, I have same error with you. And I think that it may be mysql-connector-java too old for mysql 8.

So I download mysql-connector-java-8.0.7-dmr.jar. But I don't know how to put it on TDI. 

 

Four Stars

Re: Connection Failure: Talend 6.5 to MySQL 8.0

Hi vapukov

1.PNG5.PNG

Five Stars HA
Five Stars

Re: Connection Failure: Talend 6.5 to MySQL 8.0

Thanks vapukov, that seems like a possible solution but I'm struggling on how to implement this?

 ServerOption.PNG

 

Any advise?

Thanks

Five Stars HA
Five Stars

Re: Connection Failure: Talend 6.5 to MySQL 8.0

Hi Groot,

 

You can follow the instruction here to install the connector. I have done so but still receiving the error.

Let me know if any step worked for you.

 

Cheers

One Star

Re: Connection Failure: Talend 6.5 to MySQL 8.0

Hi,

 

i had the same error and the Solution for me was to add the following parameters to the mysql Server Config:

default-authentication-plugin=mysql_native_password
collation-server = latin1_german1_ci
character-set-server = latin1

 

 

One Star

Re: Connection Failure: Talend 6.5 to MySQL 8.0

This worked for me. Thanks

Four Stars

Re: Connection Failure: Talend 6.5 to MySQL 8.0

thanks very much! this worked. I couldn't find the config file at first but then realized it is located in c:\program data\MySQL folder
I also thought I would need to add the instance=MySQLInstanceName in the parameters, like I did with SQL Server, but that wasn't the case.
thanks again.