连接mysql报zone时区错误

时间:2023-03-08 18:05:41

报错信息: 

The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone

解决:

使用navicat或者直接使用mysql命令行:

  1、查看:show variables like '%time_zone%';

  2、设置:set global time_zone='+8:00';

    或者(在navicat中手动经+8:00填进去即可)

连接mysql报zone时区错误

结果

mysql> set global time_zone = '+8:00';
Query OK, rows affected (0.00 sec) mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | |
| time_zone | +: |
+------------------+--------+
rows in set (0.01 sec) mysql>