Spring-Boot 2.0启动Mysql报时区错误

作者: 虹猫日志 | 来源:发表于2019-06-15 15:32 被阅读0次

Spring-Boot 2.0启动Mysql报时区错误
Mac的mysql和workbench连接问题解决
Hive安装使用中的一些问题
2018-0
laradock 记录日志
2019-09-29 Job for mysqld.servic
mysql 链接数不够异常
mysql的时区错误问题： The server time zo
Navicat连接docker容器中的mysql报错2003解决
SpringBoot项目访问MySQL时区错误问题

原因：安装mysql的时候时区设置的不正确，Mysql默认的是美国的时区，而我们中国大陆要比他们迟8小时，采用+8:00格式，导致数据库和系统时区差异。

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 java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:na]
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:na]
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:na]
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:488) ~[na:na]
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.15.jar:8.0.15]
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85) ~[mysql-connector-java-8.0.15.jar:8.0.15]
    at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132) ~[mysql-connector-java-8.0.15.jar:8.0.15]
    at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241) ~[mysql-connector-java-8.0.15.jar:8.0.15]
    at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265) ~[mysql-connector-java-8.0.15.jar:8.0.15]
    at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319) ~[mysql-connector-java-8.0.15.jar:8.0.15]
    at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:966) ~[mysql-connector-java-8.0.15.jar:8.0.15]
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825) ~[mysql-connector-java-8.0.15.jar:8.0.15]
    ... 88 common frames omitted

解决办法：
1. 修改Mysql配置文件my.ini

image.png
1. 重启Mysql服务
```
net stop mysql  停止当前mysql服务
net start mysql 重新启动mysql服务
```
2. 查看修改后的时区value不再显示System,为修改后的+08:00
```
 show variables like '%time_zone%';
```
image.png