use the following command to install time zone description tables into a MySQL server on a LINUX system.

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

you can then run ‘SET time_zone’¬†queries, e.g. ¬†SET time_zone = “Pacific/Auckland”