mysql时区查看与设置方法

一.查看数据库时区

show variables like'%time_zone';
mysql> show variables like "%time_zone";
+------------------+--------+
| Variable_name  | Value |
+------------------+--------+
| system_time_zone | CEST  |
| time_zone    | SYSTEM |
+------------------+--------+