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.
Nov 27, 2009