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”