일요일, 5월 26, 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

Time limit exceeded. Please complete the captcha once again.

Most Popular