| Question : | How can I set the time zone for MySQL to UK time?
| | Answer : | 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.
| | |