topic Re: Connection Failure: Talend 6.5 to MySQL 8.0 in Talend Studio

Connection Failure: Talend 6.5 to MySQL 8.0

Anonymous — Fri, 25 May 2018 14:19:56 GMT

Hi,

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

Any idea how to resolve this?

Thanks

Re: Connection Failure: Talend 6.5 to MySQL 8.0

vapukov — Sat, 26 May 2018 05:33:35 GMT

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-password

plus You must create user with old password format

Re: Connection Failure: Talend 6.5 to MySQL 8.0

Anonymous — Sat, 26 May 2018 07:56:25 GMT

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

Re: Connection Failure: Talend 6.5 to MySQL 8.0

Anonymous — Sat, 26 May 2018 08:09:36 GMT

Hi vapukov

Re: Connection Failure: Talend 6.5 to MySQL 8.0

Anonymous — Tue, 29 May 2018 12:04:28 GMT

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

Any advise?

Thanks

Re: Connection Failure: Talend 6.5 to MySQL 8.0

Anonymous — Tue, 29 May 2018 13:36:44 GMT

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

Re: Connection Failure: Talend 6.5 to MySQL 8.0

NeroVanhell — Fri, 03 Aug 2018 10:50:41 GMT

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

Re: Connection Failure: Talend 6.5 to MySQL 8.0

Anonymous — Wed, 15 Aug 2018 15:44:17 GMT

This worked for me. Thanks

Re: Connection Failure: Talend 6.5 to MySQL 8.0

Anonymous — Wed, 05 Sep 2018 09:56:42 GMT

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.