服务器返回无效的时区。转到 Advanced 选项卡并手动设置 servertimezone 属性

我的 Intelij IDE 不能连接到 MySQL 工作台的数据库服务器，它指定这是一个时区问题，并希望我转到高级选项卡并手动设置 serverTimezone 属性。

我试图寻找，如果有一个类似的问题，但我似乎找不到它。

86844 次浏览

小开

最佳答案

In the Database tool window, right click on the data source, choose Properties (Shift+Enter), click on the Advanced tab.

Set the serverTimezone property to UTC.

See also the corresponding documentation page.

小开

@CrazyCoder is correct but here is a more details answer:

In DataGrip right click on your database drop down menu click on Properties then go to Advanced and slowly look for severTimeZone as in this attachement below:

Don't forget to click on apply and test again it should work.

Done.

小开

I had same problem. Running

SET GLOBAL time_zone = '+8:00';

on MySql command line solved the problem!

小开

You can follow the picture find the configuration , Set Time zone = UTC

小开

You need to set 'serverTimezone' with 'UTC'. But use upper case!

Open Properties, in mac use (Command + ;), click on the Advanced tab.