IDEA 链接数据库失败;Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezone‘ prope

在链接数据库时

点击Test Connection出现Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' prope

IDEA 链接数据库失败;Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezone‘ prope

解决办法:

设置时区set global time_zone = '+8:00';

IDEA 链接数据库失败;Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezone‘ prope

(使用WIN+R CMD进入mysql需要配置环境变量path)

设置成功后再次点击链接即可--

IDEA 链接数据库失败;Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezone‘ prope