idea连接mysql报错Server returns invalid timezone. Go to ‘Advanced’ tab and set ‘serverTimezone’ property manually.
原因:服务器返回无效时区,转到“高级”选项卡并手动设置“serverTimezone”属性。
在mysql的命令行窗口输入以下命令即可:
show variables like ‘%time_zone%’;
set global time_zone=’+8:00’;
参考:https://blog.youkuaiyun.com/weixin_42941486/article/details/100660560