Connecting MySQL 8 to talend fails

[Bastifantasti1]

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:

 

[manodwhb]

@Bastifantasti, do you verified the below case?

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

[Bastifantasti1]

@manodwhb thanks for pointing out - yes I have.

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

[manodwhb]

@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