spring boot mybatis报错： The server time zone value '�й��׼ʱ��' is unrecognized

最新推荐文章于 2025-10-27 11:52:21 发布

原创最新推荐文章于 2025-10-27 11:52:21 发布 · 1.2w 阅读

1 ·

CC 4.0 BY-SA版权

java 专栏收录该内容

15 篇文章

订阅专栏

博客指出MySQL出现‘The server time zone value … is unrecognized’错误，给出了异常日志。分析该错误是在mysql配置的依赖包为高版本时出现，解决办法一是降低spring boot版本，二是配置mysql连接时区。

错误标识

The server time zone value ‘�й��׼ʱ��’ is unrecognized

异常日志

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 property) to use a more specifc time zone value if you want to utilize time zone support.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)
at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
at com.mysql.cj.jdbc.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:118)

解决办法：

这个错误是因为mysql配置的依赖包是高版本的情况下出现的：

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

例如我的spring boot 版本,降低版本

 <version>2.1.5.RELEASE</version>
 改为
<version>2.0.4.RELEASE</version>

配置mysql连接时区

jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC