Does Qlik Replicate support "Authentication plugin 'caching_sha2_password'" of MySQL 8 ?

[khchoy]

Hi All,

Does Qlik Replicate support "Authentication plugin 'caching_sha2_password'" of MySQL ?

User guide does not mentioned about this.

Regards,

KwangHo

[john_wang]

Hi KwangHo,

The User Guide Security requirements  mentions "The Qlik Replicate user must have Standard authentication in order to work with MySQL 8 as a source endpoint for CDC".

Hope this helps.

Regards,

John.

[lyka · Accepted solution]

Good Day!

Replicate do not support caching_sha2_password.

I have seen a workaround  without touching the caching_sha2_password.dll file and that is by running this command and using the native password, 

Please note that although this worked, it may not be acceptable due to security concerns.

Use mysql_native_password

You can use the ALTER command to change the encryption of the password to mysql_native_password instead of the latest authentication plugin caching_sha2_password

ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Thanks

Lyka

[khchoy]

Thanks lyka, , I was able to understand clearly.

Regards,

KwangHo