Skip to content

Instantly share code, notes, and snippets.

@sigridjineth

sigridjineth/change-mysql-timezone.md

Last active April 15, 2020 02:07
Show Gist options
  • Save sigridjineth/219fccf95d648f34b3df3e71ab9924d3 to your computer and use it in GitHub Desktop.
Save sigridjineth/219fccf95d648f34b3df3e71ab9924d3 to your computer and use it in GitHub Desktop.
Download ZIP
[MySQL Tip] MySQL 서버 시간 바꾸기
Raw
change-mysql-timezone.md

Change MySQL Server Time to KST

  • Configuration file에 다음을 입력한다.
[mysqld]
default-time-zone=+09:00
  • 그 뒤 MySQL을 다시 시작한다. 이제 DB의 기본 시간대가 서울로 변경되었을 것이다.

Reference

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment