当前位置: 代码迷 >> 综合 >> SpringBoot连接MySQL报错:java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized
  详细解决方案

SpringBoot连接MySQL报错:java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized

热度:53   发布时间:2023-12-15 06:23:46.0

报错内容: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.
这是MySQL默认时区引起的问题。解决办法:连接MySQL设置默认时区:

url: jdbc:mysql://localhost:3306/mybatis_test?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
  相关解决方案