topic Re: Does Qlik Replicate support "Authentication plugin 'caching_sha2_password'" of MySQL 8 ? in Qlik Replicate

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

khchoy — Thu, 17 Mar 2022 06:25:44 GMT

Hi All,

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

User guide does not mentioned about this.

Regards,

KwangHo

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

john_wang — Thu, 17 Mar 2022 07:21:16 GMT

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.

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

lyka — Thu, 17 Mar 2022 16:51:38 GMT

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

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

khchoy — Thu, 17 Mar 2022 21:45:49 GMT

Thanks lyka, , I was able to understand clearly.

Regards,

KwangHo