3

I am running a MySQL client utility, and getting this well-known error:

The server time zone value 'KST' 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.

Out-of-the-box Ubuntu 2019.04 with the database engine installed from the official Ubuntu repository (mysql Ver 14.14 Distrib 5.7.26).

How to fix it?

Appending &serverTimezone=UTC to the JDBC URL would fix the problem but unfortunately I can not control the URL used by the utility so I have to work around the problem server-side.

I tried running SET time_zone = "+09:00"; on the MySQL server, it does not fix the problem.

This might be part of the problem:

select * from mysql.time_zone_name;
Empty set (0.00 sec)

env | grep KST returns nothing.

Nicolas Raoul
  • 58,567
  • 58
  • 222
  • 373
  • Did you try the other answers here: https://stackoverflow.com/questions/26515700/mysql-jdbc-driver-5-1-33-time-zone-issue – juergen d Jul 26 '19 at 05:08

1 Answers1

3

If by KST you mean Korea Standard Time as used in South Korea, use the TZDB identifier Asia/Seoul.

SET GLOBAL time_zone = 'Asia/Seoul';

KST isn't a valid TZDB identifier.

Matt Johnson-Pint
  • 230,703
  • 74
  • 448
  • 575