Server returns invalid timezone. Go to ‘Advanced’ tab and set ‘serverTimezone’ property manually.

  • A+
所属分类:学习笔记

IDEA连接数据库报错:

Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property manually.

时区错误,

时区错误,MySQL默认的时区是UTC时区,比北京时间晚8个小时。

所以要修改mysql的时长

登陆MySQL输入:

set global time_zone='+8:00';

Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property manually.

然后权限刷新输入:

flush privileges;

zore

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: