MySQL connector/j 6.x jdbc.properties configuration, Mysql-connector-java-6.0.4.jar exception

Error message

caused By:com.mysql.cj.core.exceptions.InvalidConnectionAttributeException: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) to use a more specifc Time zone value if you want to utilize time zone support.

Reason for the occurrence:

Due to the use of MySQL connector/j more than 6.x version, and then reported the time zone error

Solution:

# # MySQL connector/j 5.x   (Legacy Connection) #jdbc. Url=jdbc:mysql://127.0.0.1:3306/test?useunicode=true&characterencoding=utf8# # # MySQL Connector/j 6.x   (new connection) JDBC.URL=JDBC:MYSQL:///TEST?SERVERTIMEZONE=UTC&characterencoding =utf8&useunicode=true&usessl=false

At the same time, the driver also recommends the use of the new driver

#数据库驱动

# # MySQL connector/j 5.x   (Legacy connection

Spring.datasource.driver-class-name=com.mysql.jdbc.driver

# # # MySQL connector/j 6.x   (new connection)Spring.datasource.driver-class-name=com.mysql.cj.jdbc.driver

MySQL connector/j 6.x jdbc.properties configuration, Mysql-connector-java-6.0.4.jar exception