The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone 问题解决

报错如下:

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.

解决:

mysql连接地址加个配置:  &serverTimezone=UTC

1 #application.properties 配置文件
2 
3 #原配置
4 jdbc.url=jdbc:mysql://127.0.0.1:3306/oasys?useUnicode=true&characterEncoding=utf-8&useSSL=false
5 
6 
7 #新配置(增加 &serverTimezone=UTC)
8 jdbc.url=jdbc:mysql://127.0.0.1:3306/oasys?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC

参考:

https://www.cnblogs.com/EasonJim/p/6906713.html 

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.

原文地址:https://www.cnblogs.com/whycai/p/13121286.html