토요일, 9월 14, 2024
HomeLinuxMysql Server time zone 설정

Mysql Server time zone 설정

Mysql Server time zone 설정

SELECT @@global.time_zone, @@session.time_zone;
mysqltimezone001

SELECT CURRENT_TIMESTAMP();
mysqltimezone002

SET @@session.time_zone=’+09:00′;
mysqltimezone003

vi /etc/my.cnf.d/server.cnf
[mysqld]
default-time-zone=’+09:00′

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular