MySQL timezone issues

[ebotunes]

I am having problems with the timezone settings in MySQL on my VPS Hosting. When I first had the VPS Hosting set up I remember having to change the Linux timezone on the server to be GMT , but I've recently noticed weird dates occurring in my app and it seems that the MySQL server timezone is set to 'MSK' (Moscow?). the dates are coming out three hours ahead so that seems about right.

The php functions time() , date() etc. all display the correct time (GMT)

mysql: SELECT now() - returns the moscow time


I found the timezone setting in MySQL through phpMyAdmin but couldnt figure out how to change it

Any ideas??

[eUKhost.com]

The initial global server time zone value can be specified explicitly at startup with the --default-time-zone=timezone option on the command line, or you can use the following line in an option file:

default-time-zone='timezone'

If you have the SUPER privilege, you can set the global server time zone value at runtime with this statement:

mysql> SET GLOBAL time_zone = timezone;

[ebotunes]

Thanks!

In the end all I had to do was restart the MySQL server, via the WHM. In doing this it picked up the timezone from the Linux server (which i'd changed since the last time MySQL started up!)

cheers,
Iain

[eUKhost.com]

Geez.

I forgot to mention that.

Anyways, good to see that your problem got sorted