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

Thirteen 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

 

-----------
Six 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. 

 

Six 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.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.