Re: MySQL Router - Windows 8.0.30 - Fails at boottrapping creation - Router configuration files
Posted by: Edwin Eu
Date: December 08, 2022 10:59AM

Hello Sir:

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.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.