spring boot 项目报错 java.sql.SQLException: The server time zone value ‘�й��׼ʱ��‘ is unrecognized

喜欢ヅ旅行 2022-12-01 05:13 111阅读 0赞

## 报错说是时区不对 ##

因为mysql-connection-java版本导致时区的问题。

pom.xml:  
![在这里插入图片描述][20190803223609804.png]

控制台报错信息：

> **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. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~\[mysql-connector-java-8.0.16.jar:8.0.16\]**  
> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~\[mysql-connector-java-8.0.16.jar:8.0.16\]  
> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~\[mysql-connector-java-8.0.16.jar:8.0.16\]  
> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~\[mysql-connector-java-8.0.16.jar:8.0.16\]  
> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~\[mysql-connector-java-8.0.16.jar:8.0.16\]  
> at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76) ~\[mysql-connector-java-8.0.16.jar:8.0.16\]

**解决方式1**

加上版本号5.1.47，如果加上版本号6.0.6也不行，可能是因为版本太高。

<dependency>
    	<groupId>mysql</groupId>
    	<artifactId>mysql-connector-java</artifactId>
    	<version>5.1.47</version>
    	<scope>runtime</scope>
    </dependency>

**解决方式2**

不加版本号或者版本号为6以上，解决方式：在连接数据库的配置文件中加上以下，时区亚洲/上海

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzMzcxMDA0_size_16_color_FFFFFF_t_70]

url: jdbc:mysql://localhost:3306/mydb?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai

**解决方式3**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzMzcxMDA0_size_16_color_FFFFFF_t_70 1]

本文原文地址：[https://blog.csdn.net/qq\_43371004/article/details/98385445][https_blog.csdn.net_qq_43371004_article_details_98385445]

[20190803223609804.png]: /images/20221123/cb789f40e8354b0bb41463d08522b5fb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzMzcxMDA0_size_16_color_FFFFFF_t_70]: /images/20221123/1f608c6a1d6e4603b0edec94f3941fce.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzMzcxMDA0_size_16_color_FFFFFF_t_70 1]: /images/20221123/3d904deae4724eb394aaff427fcf81d8.png
[https_blog.csdn.net_qq_43371004_article_details_98385445]: https://blog.csdn.net/qq_43371004/article/details/98385445