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

因此使用root用户登录mysql，按照如上图图所示操作即可。

https://www.cnblogs.com/ljy-20180122/p/9157912.html

 

如果执行set 的时候报下面的这个错。

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and"

 

 

set sql_mode = 'NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';

 

https://blog.csdn.net/huihuikuaipao_/article/details/84106480

 

show variables like '%time_zone%';
set sql_mode = 'NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';

set global time_zone='+8:00';

show variables like '%time_zone%';