I am having issues connecting to MySQL server 8.0 from Talend 6.5.
Any idea how to resolve this?
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
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.
i had the same error and the Solution for me was to add the following parameters to the mysql Server Config:
collation-server = latin1_german1_ci
character-set-server = latin1