转自:https://blog.csdn.net/qq_40891588/article/details/85052923
连接MySQL异常: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.
连接数据库时,出现时区异常:
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.
两种解决方法:
- 在数据库连接语句后添加?serverTimezone=UTC,即默认0时区,但是要注意,该语句需要跟在数据库连接语句的第一个位置,否则会报错,例如:
jdbc.url=jdbc:mysql://localhost:3306/test?serverTimezone=UTC&user&password&useUnicode=true&characterEncoding=utf-8
注意:这种方法会存在一个问题,在向数据库插入时间字段时,时间会比当前时间早8小时,即当前系统时间减8小时。
- 修改Mysql的时区为东8区,执行如下命令即可:
set global time_zone='+8:00'