首页 > 数据库技术 > 详细

PyCharm Community 2019.2 连接MySQL8.0 时区不同步的解决

时间:2019-08-27 20:30:53      阅读:290      评论:0      收藏:0      [点我收藏+]

Windows10中,PyCharm Community 2019.2  连接MySQL8.0 连接错误,IDE提示如下:

Cannot connect to "MySQL8.0".
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 utilize time zone support.

解决步骤如下,参考链接:https://stackoverflow.com/questions/930900/how-do-i-set-the-time-zone-of-mysql

一,打开MySQL8.0 Command Line Client -unicode,输入MySQL密码登陆。

二,在登陆后输入如下代码,然后回车执行,即可顺利搞定。

1 SET GLOBAL time_zone = +8:00;

 

 

PyCharm Community 2019.2 连接MySQL8.0 时区不同步的解决

原文:https://www.cnblogs.com/simyeo/p/11420028.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!