db

mysql timezone setting

sunny___ 2022. 4. 26. 16:00
반응형
  • check timezone
    • select @@global.time_zone, @@session.time_zone,@@system_time_zone;
    • select current_time;
  • modify timezone
    • sudo vim /etc/mysql/mysql.conf.d/mysqld.conf
    • 아래 줄 추가
      • default-time-zone="+00:00"
    • 그리고 재기동
      • sudo service mysql restart
반응형