Changing the connection timezone in MySQL

For Linux, BSD, and Mac OS X if you need to load the timezone table do this:

$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot mysql