Re: MySQL Router - Windows 8.0.30 - Fails at boottrapping creation - Router configuration files

[Edwin Eu]

Hello Sir:

Hello
I have XYZ application run into errors of “Authentication method ‘caching_sha2_password’ not supported by any of the available plugins” when trying to connect MySQL 8 databases.

• After I migrated MySQL 5 databases into MySQL 8 in Windows Server 2019.
• I make sure the logins to use “mysql_native_password” plugin.
• Then, I changed the INI parameter to use:
o default_authentication_plugin=mysql_native_password

Then, I checked and verified the logins plugin and it showed “mysql_native_password”

SELECT user, authentication_string, plugin, host from mysql_user;
• User name = Login_1
• Authentication_string = xxxxxx
• Plugin = mysql_native_password
• Host = %

Would you please help and advise.

Thank you in advance for your help.
-Edwin