When you install mysql it uses system time zone as a default time zone, and you may need to specify the different timezone as a default time zone.
1. stop the msql server
2. Go to http://dev.mysql.com/downloads/timezones.html and download "POSIX standard Time zone description tables, version 2011n"
3. unzip "timezone_2011n_posix.zip", copy and paste the files where mysql is installed, on my machine for windows its "C:\ProgramData\MySQL\MySQL Server 5.5\data\mysql"
4. Edit my.ini, for windows its where you have installed mysql, on my windows machine its at "C:\ProgramData\MySQL\MySQL Server 5.5", and add the following entry at the end:
default-time-zone = UTC
5. Save my.ini
6. Restart the mysql server.
7. Run the following query to check if the timezone is set to what you are after.
SELECT @@global.time_zone
Note: If you allready have the latest timezone files from the url mentioned in the step 2, you can skip step 2 and 3.
1. stop the msql server
2. Go to http://dev.mysql.com/downloads/timezones.html and download "POSIX standard Time zone description tables, version 2011n"
3. unzip "timezone_2011n_posix.zip", copy and paste the files where mysql is installed, on my machine for windows its "C:\ProgramData\MySQL\MySQL Server 5.5\data\mysql"
4. Edit my.ini, for windows its where you have installed mysql, on my windows machine its at "C:\ProgramData\MySQL\MySQL Server 5.5", and add the following entry at the end:
default-time-zone = UTC
5. Save my.ini
6. Restart the mysql server.
7. Run the following query to check if the timezone is set to what you are after.
SELECT @@global.time_zone
Note: If you allready have the latest timezone files from the url mentioned in the step 2, you can skip step 2 and 3.