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

 

 

 

​

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.