修改MySQL默认时区

1. 修改为东八区

默认数据库时区比服务器少8小时

登录到 mysql -uroot -p

查看数据库时间 select now();

查询数据库时区 show variables like '%time_zone%';

修改时区 set global time_zone = '+8:00'; set time_zone = '+8:00';

刷新 flush privileges;

重新查询时区 show variables like '%time_zone%';

$ mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.17 MySQL Community Server - GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 
mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2019-12-07 05:17:36 |
+---------------------+
1 row in set (0.00 sec)

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

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

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

mysql> 
mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone | CST    |
| time_zone        | +08:00 |
+------------------+--------+
2 rows in set (0.00 sec)

mysql> 
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> 
mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone | CST    |
| time_zone        | +08:00 |
+------------------+--------+
2 rows in set (0.00 sec)

mysql>

2. 修改配置文件

打开mysql的配置文件添加default-time_zone = '+8:00'

重启mysql