Home > MySQL > Change MySQL time to daylight savings time

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

vim /etc/my.cnf
default-time-zone = 'Australia/Sydney'

Reference: http://www.mysqlab.net/knowledge/kb/detail/topic/configuration/id/7090



Flag Counter