SpringBoot框架搭建错误记录之Mysql 时区错误

【log】

 Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is 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时区错误，默认美国时区

【修改办法】

1. 修改Mysql时区，cmd切换到安装目录下的bin

cd  F:\mysql-5.7.21-winx64\bin

mysql -u root -p

select now();                      查看mysql系统时间
 
set global time_zone = '+8:00';    设置时区更改为东八区

flush privileges;                  刷新权限

2. 修改application.yml中的url，添加    serverTimezone=GMT （格林尼治）

url: jdbc:mysql://localhost:3306/lifedemo?serverTimezone=GMT%2B8&characterEncoding=utf-8&useSSL=true

其他的时区

url: jdbc:mysql://localhost:3306/springdb?serverTimezone=Asia/Shanghai  //上海

url: jdbc:mysql://localhost:3306/lifedemo?serverTimezone=UTC&characterEncoding=utf-8&useSSL=true  //国际统一时间