mysql 时区设置

• mysql 5.7.31
• jdk 1.8

mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone | UTC    |
| time_zone        | SYSTEM |
+------------------+--------+
2 rows in set (0.00 sec)

mysql> set time_zone='+8:00'; 
mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone | UTC    |
| time_zone        | +08:00 |
+------------------+--------+
2 rows in set (0.00 sec)

• 在当前会话中设置时区，仅对当前会话有效。

mysql> set global time_zone='+8:00'; 

• 退出当前会话，在新开的会话生效。

[mysqld]
default-time_zone = '+8:00'

• 修改my.cnf需要重启MySQL