连接数据库报错Unabletoloadauthenticationplugincaching_sha2_password

报错Exception during pool initialization.

java.sql.SQLException: Unable to load authentication plugin &＃39;caching_sha2_password&＃39;.

报错与数据库有关的&＃xff0c;应该是从MySQL 8.0.4开始, 默认的认证插件从mysql_native_password 变为caching_sha2_password. 

参考https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html&＃xff0c;创建新用户和密码

参考sql&＃xff1a;
CREATE USER &＃39;sha2user&＃39;&＃64;&＃39;localhost&＃39;IDENTIFIED WITH caching_sha2_password BY &＃39;password&＃39;;

root账号修改为caching_sha2_password的任然不行。

进入mysql命令行&＃xff0c;使用如下命令解决:

ALTER USER &＃39;yourusername&＃39;&＃64;&＃39;localhost&＃39; IDENTIFIED WITH mysql_native_password BY &＃39;youpassword&＃39;;