springboot连接mysql8.x: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents

最新推荐文章于 2022-10-19 00:22:13 发布

zhoujian_Liu

最新推荐文章于 2022-10-19 00:22:13 发布

阅读量316

点赞数

CC 4.0 BY-SA版权

分类专栏： JAVA

本文链接：https://blog.youkuaiyun.com/zhoujian_Liu/article/details/86303987

JAVA 专栏收录该内容

7 篇文章

订阅专栏

在使用SpringBoot2.0连接MySQL8.x时遇到时区识别错误。通过在MySQL的my.ini配置文件中设置default-time-zone为'+08:00'，然后重启MySQL服务，可以成功解决该时区不识别的问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

使用SpringBoot2.0连接mysql8.x时出现如下错误：

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:127)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:87)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:61)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:71)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:862)
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230)
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226)
    at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1558)
    at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1623)
    at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2468)