解决mysql时区问题：java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or repr

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

蓝色心灵-海

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

阅读量321

点赞数 1

CC 4.0 BY-SA版权

分类专栏： mysql java连接mysql 文章标签： mysql时区不对

本文链接：https://blog.youkuaiyun.com/qq_28245087/article/details/86800861

mysql 同时被 2 个专栏收录

2 篇文章

订阅专栏

java连接mysql

2 篇文章

订阅专栏

本文解决了一个常见的Java操作MySQL时遇到的时区配置错误问题，详细介绍了如何通过设置服务器时区来避免'SQLException'。步骤包括使用root用户登录MySQL，查看当前时区配置，并修改为具体时区值'+8:00'。

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

一、报错详细信息

java操作nysql时的错误

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 org.mybatis.generator.internal.db.ConnectionFactory.getConnection(ConnectionFactory.java:68)
   at org.mybatis.generator.config.Context.getConnection(Context.java:526)
   at org.mybatis.generator.config.Context.introspectTables(Context.java:436)
   at org.mybatis.generator.api.MyBatisGenerator.generate(MyBatisGenerator.java:222)
   at org.mybatis.generator.api.MyBatisGenerator.generate(MyBatisGenerator.java:133)
   at com.share.store.utils.GeneratorDisplay.generator(GeneratorDisplay.java:26)
   at com.share.store.utils.GeneratorDisplay.main(GeneratorDisplay.java:32)
Caused by: com.mysql.cj.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(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
   at java.lang.reflect.Constructor.newInstance(Unknown Source)
   at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:59)
   at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:83)
   at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:128)
   at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2201)
   at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2225)
   at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1391)
   at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:993)
   at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:852)
   ... 10 more