Connection Failure: Talend 6.5 to MySQL 8.0

[Anonymous]

Hi,

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

Any idea how to resolve this?

Thanks

[vapukov]

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

[Anonymous]

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. 

mysql-connector-java-8.0.7-dmr.jar.zip

[Anonymous]

Hi vapukov

[Anonymous]

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

 

Any advise?

Thanks

[Anonymous]

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

[NeroVanhell]

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

[Anonymous]

This worked for me. Thanks

[Anonymous]

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.