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

MysqlSqlDatabaseIntellij IdeaMysql Workbench

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

Advanced

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:

enter image description here

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.

enter image description here

Solution 5 - Mysql

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionPuchkiiView Question on Stackoverflow
Solution 1 - MysqlCrazyCoderView Answer on Stackoverflow
Solution 2 - MysqlDungView Answer on Stackoverflow
Solution 3 - MysqlSeymur MammadliView Answer on Stackoverflow
Solution 4 - MysqlAlexShView Answer on Stackoverflow
Solution 5 - MysqlcoderjkView Answer on Stackoverflow