Re: set default time zone

[Alex Sadykov]

from http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html

1. Download the timezone table structure and data from http://dev.mysql.com/downloads/timezones.html

2. Copy and paste the data in your Mysql/data/mysql folder

3. Restart your mysql server.

4. mysql> SET GLOBAL time_zone = 'America/Toronto';

5. mysql> SET SESSION time_zone = 'America/Toronto';

6. Check SELECT @ @global.time_zone , @ @session.time_zone ;
It should give you the time zone you set just before.