Mysql-connector-java boot tomcat error after upgrading to 6.0

Mysql-connector-java boot tomcat error after upgrading to 6.0

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) to use a more specifc Time zone value if you want to utilize time zone support.

Solutions

After connecting the URL with a parameter servertimezone=gmt (after adding this parameter will be able to successfully link the database), where the time zone can be set according to their own database settings.

There may also be another error, MySQL new security settings require SSL connection, here you can add a parameter userssl=false, or you can set up SSL

In addition, 6.0.2 version of the driverclassname is no longer the original path, changed to Com.mysql.cj.jdbc.Driver

Example:

Jdbc.driverclassname=com.mysql. CJ. Jdbc. Driver

Jdbc.url=jdbc:mysql://192.168.1.2:3306/test? servertimezone=gmt&userssl=false

Mysql-connector-java boot tomcat error after upgrading to 6.0