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

Question

My Intelij IDE wont connect to my database server of MySQL Workbench, it specifies it as a timezone problem and wants me to go to advanced tab and set serverTimezone property manually.

I tried looking if there where a similar problem but i cant seem to find it.

Do you mean that you can't find [this dialog](https://i.imgur.com/kmMgJ8T.png)? — CrazyCoder, Aug 26 '19 at 22:39
Setting the paramter to UTC fixed it for me too. Interesting reasons: https://stackoverflow.com/questions/930900/how-do-i-set-the-time-zone-of-mysql — Grimax, Mar 18 '20 at 15:15

score 233 · Accepted Answer · edited Oct 22 '19 at 11:17

233

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.

edited Oct 22 '19 at 11:17

arntg

1,557
14
12

answered Aug 27 '19 at 02:27

CrazyCoder

389,263
172
990
904

1

A little hidden in the answer but this helped me. Setting the paramter to UTC fixed it for me. – Mark E Sep 04 '19 at 15:22

score 16 · Answer 2 · answered Sep 09 '19 at 17:28

@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.

score 7 · Answer 3 · answered Sep 16 '19 at 20:00

7

I had same problem. Running

SET GLOBAL time_zone = '+8:00';

on MySql command line solved the problem!

answered Sep 16 '19 at 20:00

Seymur Mammadli

1,724
15
13

score 3 · Answer 4 · answered Apr 23 '21 at 09:31

3

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

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

answered Apr 23 '21 at 09:31

AlexSh

1,468
15
12

score -1 · Answer 5 · edited Sep 04 '20 at 07:12

-1

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

edited Sep 04 '20 at 07:12

spike 王建

1,556
5
14

answered Sep 03 '20 at 23:59

coderjk

1

2

Please, add more details to your answer. – Cosmin Staicu Sep 04 '20 at 05:34

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

5 Answers5