MySQL Forums
Forum List  »  Connector/Node.js

Authentication method ‘caching_sha2_password’ not supported by any of the available plugins
Posted by: Edwin Eu
Date: December 08, 2022 10:51AM

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 someone please help and advise.
Thank you in advance for your help.
-Edwin

Options: ReplyQuote


Subject
Written By
Posted
Authentication method ‘caching_sha2_password’ not supported by any of the available plugins
December 08, 2022 10:51AM


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.