背景:
通过spring-boot-starter-data-jpa和mysql-connector-java 连接mysql数据库
1.在jdbc 连接地址后面加上&serverTimezone=GMT%2B8
UTC是统一标准世界时间 ,GMT%2B8 东八区
2.Mysql时区错误:
mysql> show variables like '%time_zone%' ;
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | |
| time_zone | SYSTEM |
+------------------+--------+
2 rows in set (0.05 sec)
执行这句sql就能修改mysql时区
mysql> set global time_zone='+8:00';
Query OK, 0 rows affected (0.01 sec)