The time zone of the database connection is faulty

Exception information

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.

...

...

If you want to use time zone support, you must configure the server or JDBC driver to use a more specific time zone value via the server Time zone configuration property.

Abnormal reason

This is because mysql has been upgraded to 8.0 and above with many new features and improved security. Of course, there are also some tedious things to consider, such as the time zone.

The solution

1、By configuring the connection string for the JDBC driver

即配置url参数中的serverTimezone属性来解决异常，需要在连接字符串 url 后加上 serverTimezone=UTC.

 

2、Check the current mysql system time

select now();

3、View the current mysql section

show variables like "%time_zone%";

4、 Changing the mysql time zone

//修改mysql全局时区为东八区，即表示北京时间

 

set global time_zone = '+8:00';

 

flush privileges;

 

//时区修改生效之后，再次查询mysql时区

 

show variables like "%time_zone%";