Bug #11400 problem with global time_zone system variable
Submitted: 16 Jun 2005 21:58 Modified: 17 Jun 2005 6:19
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.7-beta-nt OS:Microsoft Windows (Windows XP)
Assigned to: CPU Architecture:Any

[16 Jun 2005 21:58] [ name withheld ]
Description:
I have read some online document saying that I can set the time_zone variable by running some scripts. However, the time_zone variable falls back to default after MySQL server restart.

How to repeat:
First, we the time_zone to GMT by doing this:

set global time_zone='+00:00';

To see the time_zone variable, I run this:

select @@global.time_zone;

It will say the time_zone is "+00:00", which is what I want. 

However, after restarting MySQL server, the time_zone falls back to "SYSTEM". 

So, is there any significant difference between global and session variables?
[17 Jun 2005 6:19] Geert Vanderkelen
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

http://dev.mysql.com/doc/mysql/en/server-system-variables.html
Put it in your my.cnf or my.ini to make it permanent