Server returns invalid timezone. Go to Advanced tab and set servertimezone property manually
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!