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.

[john_wang]

Hello @desmondchew ,

Update about this issue:

Support for caching SHA-2 pluggable authentication with MySQL endpoints

Replicate May 2024 introduces support for caching SHA-2 pluggable authentication (caching_sha2_password) when working with MySQL sources or targets, either on-premises or in the cloud. In previous versions, only Native Pluggable Authentication (mysql_native_password) was supported.

Hope this helps.

John.