Exception in thread "main" java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password'.

这个错误是由于MySQL低版本5+和8+以上的连接安全机制不兼容导致的。解决方案是在当前项目的pom.xml配置高版本的mysql-java连接器，例如：

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.30</version>
</dependency>

如果你已经使用了高版本的连接器，那么可能是因为你的MySQL服务器使用了不同的身份验证插件。你可以尝试更改MySQL服务器的身份验证插件，例如使用mysql_native_password插件。你可以通过以下命令更改：

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

其中，'username'和'password'分别是你的用户名和密码。如果你不知道你的用户名和密码，可以使用以下命令查看：

SELECT user,authentication_string,plugin,host FROM mysql.user;

相关问题

java.sql.sqlexception: unable to load authentication plugin 'caching_sha2_password'.

这是一个 MySQL 的错误，表示无法加载认证插件 caching_sha2_password。这可能是因为数据库服务器的版本较低，不支持该认证插件。建议更新数据库服务器至最新版本或者更换其他认证插件。

java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password'.

This error occurs when the MySQL server is configured to use the caching_sha2_password authentication plugin, but the JDBC driver used by the Java application is not compatible with this plugin.

To resolve this issue, you can do one of the following:

1. Upgrade the JDBC driver to a version that supports the caching_sha2_password authentication plugin. You can download the latest version of the JDBC driver from the MySQL website.

2. Change the MySQL server's authentication plugin to a plugin that is supported by the JDBC driver. For example, you can change the authentication plugin to mysql_native_password by running the following command in the MySQL console:

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

Replace 'username' and 'password' with the actual username and password used to connect to the MySQL server.

After making these changes, restart the MySQL server and try connecting to it from the Java application again.