MySQL修改时区

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2019-07-12 15:02:48 |
+---------------------+
1 row in set (0.00 sec)

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

mysql> set global time_zone = ‘+8:00‘;
Query OK, 0 rows affected (0.00 sec)

mysql> set time_zone = ‘+8:00‘;
Query OK, 0 rows affected (0.00 sec)

/etc/my.cnf

[mysqld]
default-time_zone = ‘+8:00‘