项目启动报错‘java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password'.’;
检查本地MySql版本:【C:\ProgramData\MySQL\MySQL Server 8.0】
检查项目jar包版本:【mysql-jdbc-5.1.20.jar】
初步断定是由于jar包版本过低导致,然后去下了个8.0的jar包,之后成功启动。
下载地址:【mysql-connector-java】
备注:
如果还是报错:
com.alibaba.druid.pool.vendor.MySqlValidConnectionChecker.<init>(53) | Cannot resolve com.mysq.jdbc.Connection.ping method. Will use 'SELECT 1' instead.
java.lang.NullPointerException
at com.alibaba.druid.pool.vendor.MySqlValidConnectionChecker.<init>(MySqlValidConnectionChecker.java:48)
at com.alibaba.druid.pool.DruidDataSource.initValidConnectionChecker(DruidDataSource.java:843)
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
请更新jar包:druid - 1.0.4.jar
https://mvnrepository.com/artifact/com.alibaba/druid/1.1.11