topic Re: Connecting MySQL 8 to talend fails in Talend Studio

Connecting MySQL 8 to talend fails

Bastifantasti1 — Sat, 16 Nov 2024 02:19:52 GMT

Hi all,

I am using Talend Open Studio for Data integration [version 7.2.1] and I try to connect MySql [version 8.0.2/the newest].

When trying to connect I reveice the error message: Please change the databasesettings.
I have taken the credentials out of the sql workbench server connection details.

Could you guys please let me know if I am using the wrong versions, need to use any kind of adapter or maybe have inserted wrong credentials.

Best regards
Bastian
Please see below the screenshot:

Re: Connecting MySQL 8 to talend fails

manodwhb — Tue, 26 May 2020 12:10:48 GMT

@Bastifantasti, do you verified the below case?

https://community.talend.com/t5/Design-and-Development/MySQL-8-Support/td-p/122765

Re: Connecting MySQL 8 to talend fails

Bastifantasti1 — Tue, 26 May 2020 12:48:12 GMT

@manodwhb thanks for pointing out - yes I have.

since the last questions is not answered I am still wondering where my issue is ...

Re: Connecting MySQL 8 to talend fails

manodwhb — Tue, 26 May 2020 14:36:35 GMT

@Bastifantasti , have you verified below reply in below case?

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

https://community.talend.com/t5/Design-and-Development/MySQL-8-Support/td-p/122765