[How To] Update or Change MySQL database timezone

mysql logo

Sometimes you need to change the timezone used by MySQL database for some  specific applications or globally. The below steps will guide you to change the MySQL time zone: 1) Check time_zone* tables in mysql database. If it is empty then insert Zone Info data using following command  mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root …

Read More »