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

mysql sql database intellij-idea mysql-workbench
Puchkii picture Puchkii · Aug 27, 2019 · Viewed 56.9k times · Source

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.

Answer

CrazyCoder picture CrazyCoder · Aug 27, 2019

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

Related questions

'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More
MySQL Error: : 'Access denied for user 'root'@'localhost'

$ ./mysqladmin -u root -p 'redacted' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' How can I fix this?

Read More
How do I restore a dump file from mysqldump?

I was given a MySQL database file that I need to restore as a database on my Windows Server 2008 machine. I tried using MySQL Administrator, but I got the following error: The selected file was generated by mysqldump and cannot …

Read More