CODEWITHSUNDEEP
mysqlubuntujdbctimezone
Nicolas Raoul
Nicolas Raoul

Reputation: 60213

The server time zone value 'KST' is unrecognized: How to fix server-side?

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.

Upvotes: 3

Views: 1134

Answers (1)

Matt Johnson-Pint
Matt Johnson-Pint

Reputation: 241728

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.

Upvotes: 3

Related Questions