Modify the MySQL time zone, involving the time_zone Parameter

Modify the MySQL time zone. The time_zone parameter must be used to view the current mysql time zone.

[html]mysql> show variables like '%time_zone%';     +------------------+--------+  | Variable_name    | Value  |  +------------------+--------+  | system_time_zone | CST    |  | time_zone        | SYSTEM |  +------------------+--------+  2 rows in set (0.00 sec)  

 

1. You can modify the time zone by adding default-time-zone = timezone under [mysqld] under my. cnf. For example, if the default-time-zone = '+' has been modified, remember to restart msyql and add it under [mysqld, otherwise, the unknown variable 'default-time-zone = + 8:00 '2 will appear. Alternatively, you can use the command line to modify it online.

[Html] set time_zone = timezone, for example, Beijing time (GMT + 0800) set time_zone = '+'; below: mysql> set time_zone = '+'; Query OK, 0 rows affected (0.00 sec) mysql> show variables like '% time_zone % '; + rows + -------- + | Variable_name | Value | + ---------------- + -------- + | system_time_zone | CST | time_zone | + 08:00 | + ---------------- + -------- + 2 rows in set (0.00 sec)

 

3. Use select now () to verify the time zone.

[html]mysql> show variables like '%time_zone%';     +------------------+--------+  | Variable_name    | Value  |  +------------------+--------+  | system_time_zone | CST    |  | <span style="color:#3366ff;">time_zone        | +08:00 </span>|  +------------------+--------+  2 rows in set (0.00 sec)    mysql> select now();  +---------------------+  | now()               |  +---------------------+  | <span style="color:#3333ff;">2013-08-05 10:35:31 </span>|  +---------------------+  1 row in set (0.00 sec)    mysql>  <span style="color:#ff0000;">set </span><span style="color:#ff0000;">time_zone='+0:00';  </span>Query OK, 0 rows affected (0.00 sec)  [html]mysql> show variables like '%time_zone%';  +------------------+--------+  | Variable_name    | Value  |  +------------------+--------+  | system_time_zone | CST    |  |<span style="color:#ff0000;"> time_zone        | +00:00 </span>|  +------------------+--------+  2 rows in set (0.00 sec)  [html]mysql> select now();  +---------------------+  | now()               |  +---------------------+  | <span style="color:#ff0000;">2013-08-05 02:35:43 </span>|  +---------------------+  1 row in set (0.00 sec)