Could not connect to source endpoint running MySQL 8

[desmondchew]

Hi,

We have a source MySQL database running on version 5.7. We attempted to connect with a new task created. But hit into the following error. Please advise how to workaround?

Cannot initialize subtask
Failed while preparing stream component 'st_0_Meridian_Prod'.
Errors in MySQL server validation.
Error 1045 (Plugin caching_sha2_password could not be loaded: The specified module could not be found. Library path is 'C:/Program Files (x86)/mariadb-connector-c/lib/mariadb/plugin/caching_sha2_password.dll') connecting to MySQL server

[john_wang · Accepted solution]

Hello @desmondchew ,

Thanks for sharing the information. The mysql_native_password authentication plugin works fine in the existing MySQL major versions still (8.x, 8.1).  At least in our labs test, ODBC 8.0.32 works fine with MySQL 8.1.0 Server in our smoking tests. Qlik R&D will support the newer authentication plugins in the coming Replicate patch/versions as well.

Hope this helps.

Regards,

John.