set the time zone for MySQL to UK time?

alfiecrosby · #1 (**permalink**) 04-16-2008, 09:12 PM

Hi there...

this is my first time to post here...
thanks webmasterground for accepting me to be part of this community...

I have a question:
How can I set the time zone for MySQL to UK time?

thanks for any reply.....

Crafterz · #2 (**permalink**) 04-16-2008, 09:37 PM

Quote:

Originally Posted by http://www.alt-php-faq.org/local/76/

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.

Just searched google.