报错信息:
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> set global time_zone = '+8:00'; Query OK, 0 rows affected (0.00 sec) mysql> show variables like '%time_zone%'; +------------------+--------+ | Variable_name | Value | +------------------+--------+ | system_time_zone | | | time_zone | +08:00 | +------------------+--------+ 2 rows in set (0.01 sec) mysql>