반응형


<확인>

*간단한 확인 
select now();

*Time Zone 설정이 되어 있지 않다면 0
select count(*) from mysql.time_zone;

*Time Zone 국가 (KST, EEST ..) 
select @@system_time_zone;

*Time Zone 정보 
 SELECT @@global.time_zone, @@session.time_zone;
> SYSTEM SYSTEM



<변경> 
vi /etc/my.cnf

set time_zone='-07:00'; 

추가후 

systemctl restart mysqld

확인
select now();

[출처]https://www.inmotionhosting.com/support/website/databases/how-to-change-mysql-server-time-zone

728x90

+ Recent posts