MySql高版本报错caching_sha2_password

[zxiaofan]

trafficstars

MySql 高版本（8.0.20） 链接 提示： SEVERE: java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password'. java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password'.

插件如何导入安装呢

[xuzaoya]

你可以试试更高版本的驱动Connector/J 8.0.28，下载地址https://dev.mysql.com/downloads/connector/j/ excel插件使用说明http://c.raqsoft.com.cn/article/1648892334752

[zxiaofan]

下载高版本connector/j/也不行，新建账号解决 create user 'spl'@'%' identified with mysql_native_password by 'zxf123456';