Server returns invalid timezone. Go to Advanced tab and set servertimezone property manually
MysqlSqlDatabaseIntellij IdeaMysql WorkbenchMysql Problem Overview
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.
Mysql Solutions
Solution 1 - Mysql
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.
Solution 2 - Mysql
@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.
Solution 3 - Mysql
I had same problem. Running
SET GLOBAL time_zone = '+8:00';
on MySql command line solved the problem!
Solution 4 - Mysql
You need to set 'serverTimezone' with 'UTC'. But use upper case!
Open Properties, in mac use (Command + ;), click on the Advanced tab.
Solution 5 - Mysql
You can follow the picture find the configuration , Set Time zone = UTC