连接MySQL异常：The server time zone value '???ú±ê×??±??' is unrecognized or represents more than one time

转自：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'