因此使用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%';