MySQL: The server time zone value 'AEDT' is unrecognized or represents more than one time zone
insights Stats
warning Please login first to view stats information.
Raymond
SQL Databases
SQL relational databases incl. SQLite, SQL Server, MySQL, PostgreSQL, Oracle, etc.
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 4 years ago
copyright
This page is subject to Site terms.
comment Comments
No comments yet.