Mysql 查看修改默认时区

mysql> show variables like "%time_zone%";
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone | CST    |
| time_zone        | SYSTEM |
+------------------+--------+
2 rows in set (0.01 sec)

mysql> SET time_zone = "+8.00";
mysql> show variables like "%time_zone%";

mysql> SET global time_zone = "+8.00";

# 打开Mysql 的配置文件 my.ini
[mysqld]
default-time_zone = '+8:00'