MySql数据库错误整理

1. MySQLNonTransientConnectionException: Could not create connection to database server.
   因为mysql8和之前的版本的driver不同了：

driver: com.mysql.cj.jdbc.Driver

2. WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
   mysql在ssl连接时出了问题：

3. 在数据库连接的url中添加useSSL=false;

jdbc:mysql://localhost:3306/test?useSSL=false
如果在双引号里面，url后面又有其他参数，可以使用“&”代替“&”，例如：

“jdbc:mysql://localhost:3306/sql_test?useUnicode=true&characterEncoding=UTF-8&useSSL=false”

4. Authentication plugin ‘caching_sha2_password’ cannot be loaded
   因为MySQL8.0改变了身份验证方式,之前版本是mysql_native_password，现在改成了caching_sha2_password。

解决办法：

修改验证方式：

ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY ‘你的密码’;

因为本机将localhost改成%，所以我需要执行

ALTER USER root@%IDENTIFIED WITH mysql_native_password BY ‘123456’;

5. 使用mysql数据库：java.sql.SQLException: Unknown system variable ‘tx_isolation’

因为数据库版本比较高而数据库驱动版本比较低，使用最新的数据库驱动

<dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.13</version>
    </dependency>

同时驱动名跟新为：com.mysql.cj.jdbc.Driver

参考文章：

https://blog.csdn.net/qq_15003505/article/details/80463174
http://blog.csdn.net/u010429286 https://blog.csdn.net/u010429286/article/details/77750177
https://blog.csdn.net/zixiao217/article/details/80156362
https://blog.csdn.net/always_younger/article/details/80421783