Discussion board
How can I set the time zone for MySQL to UK time
By Sheetal Panday
Hi,
How can I set the time zone for MySQL to UK time
Reply
Post   Reset
Teacher SiliconIndia replied to Sheetal Panday Friday, November 27, 2009
Hi sheetal,

If you set the environment variable TZ=GB, then start MySQL the time zone will be set to UK time.

I.E. (Linux only)
bash:#TZ=GB
bash:#export TZ
bash:#mysqld &

You can also set environment variables in my.cnf; In the data (normally var) directory.