mysql错误：java.sql.SQLException: The server time zone value ‘�й��׼ʱ��’ is unrecognized or represents more than one time zone.

king linux 2023-02-27 852浏览 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 property) to use a more specifc time zone value if you want to utilize time zone support.

这是SpringBoot整合MySQL的依赖包版本过高,在高版本的MySQL依赖中数据库和系统时区差异所造成的。系统为SQL默认美国时间,而我们中国要比他们迟8小时,因此将时区设置为当前系统时区即可,采用+8:00格式

两种解决方案

1.降低 mysql-connector-java依赖版本（使用5.1.x版本即可）

<dependency>
　　<groupId>mysql</groupId>
　　<artifactId>mysql-connector-java</artifactId>
　　<version>5.1.35</version>
</dependency>

2.在JDBC连接url后添加时区属性：

&serverTimezone=GMT%2B8

转载请注明：IT运维空间 » linux » mysql错误：java.sql.SQLException: The server time zone value ‘�й��׼ʱ��’ is unrecognized or represents more than one time zone.

继续浏览有关数据库技术文章/教程的文章

mysql错误：java.sql.SQLException: The server time zone value ‘�й��׼ʱ��’ is unrecognized or represents more than one time zone.

发表评论

最新文章

热门文章

热评文章

mysql错误：java.sql.SQLException: The server time zone value &#8216;�й���׼ʱ��&#8217; is unrecognized or represents more than one time zone.

你可能喜欢:

发表评论

最新文章

热门文章

热评文章

mysql错误：java.sql.SQLException: The server time zone value ‘�й��׼ʱ��’ is unrecognized or represents more than one time zone.