How to Fix \'Unable to load authentication plugin \'caching_sha2_password\'\' in MySQL?

How to resolve Unable to load authentication plugin 'caching_sha2_password' issue

Eclipse users often encounter an error message when starting their application: "Could not discover the dialect to use. java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password'." This issue arises because MySQL has changed the default authentication plugin to 'caching_sha2_password' from 'mysql_native_password' in version 8.0.4 and higher.

To resolve this issue, you can execute the following command:

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

Replace 'username' and 'password' with your actual database credentials.

This command will reset the authentication plugin for the specified user back to 'mysql_native_password', enabling you to connect successfully to your database.

For further details, refer to the official MySQL Reference Manual.

The above is the detailed content of How to Fix \'Unable to load authentication plugin \'caching_sha2_password\'\' in MySQL?. For more information, please follow other related articles on the PHP Chinese website!