java.sql.SQLException: The server time zone value is unrecognized or represents more

原创

已于 2023-11-20 08:04:18 修改 · 845 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#开发语言 #java #seata #mysql时区错误 #异常系列

于 2023-11-19 16:38:04 首次发布

16:27:34.579 ERROR --- [ionPool-Create-1016856028] com.alibaba.druid.pool.DruidDataSource   : create connection SQLException, url: jdbc:mysql://127.0.0.1:3306/seata?useUnicode=true&rewriteBatchedStatements=true, errorCode 0, state 01S00
==>
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) ~[na:na]
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[na:na]
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[na:na]
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[na:na]
        at com.mysql.cj.jdbc.excepti