MySQL time_zone (Asia/Seoul)

MySQL time_zone

SELECT @@global.time_zone, @@session.time_zone;
SET GLOBAL time_zone = 'Asia/Seoul';
SET time_zone = 'Asia/Seoul';

SELECT b.name, a.time_zone_id
FROM mysql.time_zone a
JOIN mysql.time_zone_name b ON a.time_zone_id = b.time_zone_id
WHERE b.name LIKE '%Seoul%';

없으면 timezone 테이블 로드: https://dev.mysql.com/downloads/timezones.html

[mysqld]
default-time-zone = Asia/Seoul