--查看数据库时区设置
mysql> show variables like "%time_zone%";
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone | UTC    |
| time_zone        | SYSTEM |
+------------------+--------+
--修改当前会话时区，退出msql后 time_zone 会恢复成修改前的值
mysql> set time_zone = \'+8:00\';
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like "%time_zone%";
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone | UTC    |
| time_zone        | +08:00 |
+------------------+--------+

—-修改全局会话时区
mysql> set global time_zone = \'+8:00\';
mysql> set time_zone = \'+8:00\';
mysql> flush privileges;

 

版权声明：本文为jinyin原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/jinyin/p/10969725.html