mysql错误汇总

错误一：

Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

解决方法：将配置文件中的com.mysql.jdbc.Driver改为com.mysql.cj.jdbc.Driver，这个错误在mysql的高版本中出现

错误二：

Establishing SSL connection without server's identity verification is not re...

解决方法：在配置文件如：jdbc:mysql:///:3366:test?useUnicode=true&characterEncoding=utf-8&useSSL=true

在末尾加上&useSSL=false即可，这是在高版本中出现的证书认证问题

错误三：

ERROR [Druid-ConnectionPool-Create-2126690559] - create connection error
java.sql.SQLException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:127)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:87)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:61)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:71)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:862)
	

解决方法：在jdbc.jdbcUrl=jdbc:mysql:///db_hms?useUnicode=true&characterEncoding=utf-8&useSSL=false 

后添加&serverTimezone=UTC即可，即jdbc.jdbcUrl=jdbc:mysql:///db_hms?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC

问题四：

java.sql.SQLNonTransientConnectionException: Cannot load connection class because of underlying exce

解决方法：一般是由与数据库的url错误，仔细检查一下就好了

问题五：

ERROR [Druid-ConnectionPool-Create-321551702] - create connection error java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed

在访问数据的链接中加入以下代码即可

allowPublicKeyRetrieval=true

完整的如（以下为mysql8.0及以上版本）：

jdbc.jdbcUrl=jdbc:mysql:///db_hms?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true

---

后续更新中......