查看当前时区
> show variables like '%time_zone%'; +------------------+--------+ | Variable_name | Value | +------------------+--------+ | system_time_zone | UTC | | time_zone | SYSTEM | +------------------+--------+ 2 rows in set (0.00 sec)
临时修改时区
> set time_zone = '+8:00'; Query OK, 0 rows affected (0.00 sec)
彻底修改时区
# vi /etc/my.cnf
[mysqld]
default-time_zone = '+8:00'