首页 > 数据库技术 > 详细

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

时间:2021-01-12 23:59:01      阅读:60      评论:0      收藏:0      [点我收藏+]

 项目启动报错,错误信息如下:

Caused by: java.sql.SQLException: Unable to load authentication plugin ‘caching_sha2_password‘.
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:868) ~[mysql-connector-java-5.1.43.jar:5.1.43]
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:864) ~[mysql-connector-java-5.1.43.jar:5.1.43]
    at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1746) ~[mysql-connector-java-5.1.43.jar:5.1.43]
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226) ~[mysql-connector-java-5.1.43.jar:5.1.43]
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2198) ~[mysql-connector-java-5.1.43.jar:5.1.43]
    at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2045) ~[mysql-connector-java-5.1.43.jar:5.1.43]
    ... 62 common frames omitted

 

环境信息:

  mysql 8.0.22

错误原因:

主要原因8.x版本的验证模块和之前版本不同:

5.x版本是:default_authentication_plugin=mysql_native_password

8.x版本是:default_authentication_plugin=caching_sha2_password

解决方法:

升级mysql 驱动

<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>8.0.22</version>
  <!--<version>5.1.22</version>-->
</dependency>

 注意升级完驱动需要修改

8.x:  driver-class-name=com.mysql.cj.jdbc.Driver
5.x:  driver-class-name=com.mysql.jdbc.Driver

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

原文:https://www.cnblogs.com/sandyyeh/p/14269905.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!