首先需要查看mysql的当前时区,用time_zone参数
mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | CST |
| time_zone | SYSTEM |
+------------------+--------+
第一步
mysql> set global time_zone = '+08:00'; set time_zone = '+08:00';
mysql> flush privileges;
Query OK, rows affected (0.00 sec)
第二部
修改的/etc/my.cnf的
default-time-zone = '+08:00'
第三部,重启mysql服务器,不重启是不会生效的.
[root@iZbp15d0fgh0v1wwql5r4uZ etc]# init.d/mysql restart
修改成功后是:
mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | CST |
| time_zone | +: |
+------------------+--------+
第二部很重要,不然怎么都设置无效