spring boot 连接数据库的一系列问题

问题一

Unable to load authentication plugin 'caching_sha2_password'.

解决方法：先登录数据库，然后更改mysql数据库密码：

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'pass123';

问题二

发现数据库里没有代码中需要连接的数据库
解决方法：创建数据库：先连接数据库，然后创建，再使用
//创建library数据库

CREATE DATABASE library;

使用数据库

use library;

问题三

java.sql.SQLException: Unknown system variable 'query_cache_size'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:545) ~[mysql-connector-java-6.0.5.jar:6.0.5]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513) ~[mysql-connector-java-6.0.5.jar:6.0.5]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115) ~[mysql-connector-java-6.0.5.jar:6.0.5]
at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983) ~[mysql-connector-java-6.0.5.jar:6.0.5]
at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1936) ~[mysql-connector-java-6.0.5.jar:6.0.5]
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1422) ~[mysql-connector-java-6.0.5.jar:6.0.5]
at com.mysql.cj.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:2831) ~[mysql-connector-java-6.0.5.jar:6.0.5]
at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:2381) ~[mysql-connector-java-6.0.5.jar:6.0.5]
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1739) ~[mysql-connector-java-6.0.5.jar:6.0.5]
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1596) ~[mysql-connector-java-6.0.5.jar:6.0.5]

把这个删掉，然后下载一个高版本的导进来https://mvnrepository.com/artifact/mysql/mysql-connector-java


这里记得改