360SDN.COM

首页/MySQL/列表

mysql8.0.11运行报The server time zone value is unrecognized or re

来源:  2018-08-21 14:34:53    评论:0点击:

mysql8.0.11运行报The server time zone value '?D1ú±ê×?ê±??' is unrecognized or represents more ..解决办法




具体错误:The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utili

出现这个错误的主要原因是mysql时区设置错误;

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

show variables like '%time_zone%';

set global time_zone='+8:00';

 

来源:https://blog.csdn.net/lubin100/article/details/81095395
为您推荐

友情链接 |九搜汽车网 |手机ok生活信息网|ok生活信息网|ok微生活
 Powered by www.360SDN.COM   京ICP备11022651号-4 © 2012-2016 版权