MySQL: The server time zone value 'AEDT' is unrecognized or represents more than one time zone

access_time 19 days ago visibility10 comment 0

Issue context

When connecting to MySQL using JDBC driver, the following error is encountered:

Underlying cause: java.sql.SQLException : The server time zone value 'AEDT' 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 specific time zone value if you want to utilize time zone support.

AEDT is Australian Eastern Daylight Time (AEDT).

Resolution

This error can be avoided by adding serverTimezone=UTC in the connection string to ignore the server time zone in client side as the error message itself suggests.

Thus, we can update JDBC connection string:

jdbc:mysql://localhost/hive_metastore?serverTimezone=UTC
info Last modified by Raymond 19 days ago copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Follow Kontext

Get our latest updates on LinkedIn or Twitter.

Want to publish your article on Kontext?

Learn more

More from Kontext

visibility 4
thumb_up 0
access_time 16 days ago

To start MySQL service on a UNIX-alike system or on Windows Subsystem for Linux (WSL), simply run the following command: sudo service mysql start The output looks like the following: * Starting MySQL database server mysqld ...

visibility 9728
thumb_up 2
access_time 3 years ago

This page documents the detailed steps to load CSV file from GCS into BigQuery using Dataflow to demo a simple data flow creation using Dataflow Tools for Eclipse. However it doesn’t necessarily mean this is the right use case for DataFlow. Alternatively bq command line or programming APIs ...

visibility 1622
thumb_up 0
access_time 9 months ago

Python JayDeBeApi module allows you to connect from Python to Teradata databases using Java JDBC drivers. In article Connect to Teradata database through Python , I showed how to use teradata package to connect to Teradata via Teradata ODBC driver. This article demos how to use this JayDeBeApi ...