Getting error for a new tasks using MySQL as both source and target endpoints.

[desmondchew]

I have setup a new task using MySQL as source and target end points. We do have license using MySQL as source.

We are unable to load not a single table. Both MySQL are running 8.0.31. Qlik replicate server is Nov 2021 version odbc driver 8.0.23 connector.

Stream component 'st_0_OnPrem_MySQLDev' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_OnPrem_MySQLDev'.
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 'hostname A'

Please help.

Regards

Thanks
Desmond

[john_wang]

Hello @desmondchew ,

Glad to hear that.

if the provided solution helps please "Accept as Solution". Thank you,

John.