--修改当前会话时区,退出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;
--查看数据库时区设置mysql> show variables like "%time_zone%"; +------------------+--------+ | Variable_name | Value | +------------------+--------+ | system_time_zone | UTC | | time_zone | SYSTEM | +------------------+--------+