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