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
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.