Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Set timezone for MySQL
# Populate the Time Zone Tables from your system into the MySQL:
# @see https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html#time-zone-installation
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
# In `/etc/mysql/my.cnf` add following line under [mysqld] config group:
[mysqld]
default-time-zone=Europe/Kiev
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment