How to fix server time zone causing exception when trying to connect to MySQL instance with DataGrip?

mysql timezone datagrip
ahsteele picture ahsteele · Apr 25, 2019 · Viewed 8k times · Source

When attempting to connect to a MySQL instance with DataGrip I am receiving a com.mysql.cj.exceptions.InvalidConnectionAttributeException exception:

The server time zone value 'XXX' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

Where XXX is my server's timezone (I also love the typo in the exception specifc). This error prevents me from creating a connection to the MySQL server. What is causing this issue?

Answer

ahsteele picture ahsteele · Apr 25, 2019

Your server's time zone is not specific. To get around this you need to set the serverTimezone property to a value that is specific. The simplest choice is to set it to UTC under the Advanced tab:

Advanced Tab serverTimeZone set

To be clear I'm not sure of the ramifications of this, but it did allow me to connect.

Related questions

How do I set the time zone of MySQL?

On one server, when I run: mysql> select now(); +---------------------+ | now() | +---------------------+ | 2009-05-30 16:54:29 | +---------------------+ 1 row in set (0.00 sec) On another server: mysql> select now(); +---------------------+ | now() | +---------------------+ | 2009-05-30 20:01:43 | +---------------------+ 1 row in set (0.00 sec)

Read More
MySQL JDBC Driver 5.1.33 - Time Zone Issue

Some background: I have a Java 1.6 webapp running on Tomcat 7. The database is MySQL 5.5. Previously, I was using Mysql JDBC driver 5.1.23 to connect to the DB. Everything worked. I recently upgraded to Mysql JDBC driver 5.1.33. After the upgrade, Tomcat would …

Read More
How do I get the current time zone of MySQL?

Anyone knows if there is such a function in MySQL? UPDATE This doesn't output any valid info: mysql> SELECT @@global.time_zone, @@session.time_zone; +--------------------+---------------------+ | @@global.time_zone | @@session.time_zone | +--------------------+---------------------+ | SYSTEM | SYSTEM | +--------------------+---------------------+ …

Read More