I use this in my.cnf (along with mysqld_multi settings fwiw) and it works
great (mysql version 4.0.X):
timezone = GMT
It depends on how you start up mysqld.. If you don't use mysqld_safe, the
above wont work for you.
Flying Crocodile Inc, Unix Systems Administrator
On Wed, 21 Sep 2005, Petr Chardin wrote:
> > I've tried putting TZ = GMT and TZ = UTC into the my.cnf file but then
> > mysql won't even start.
> These should be set as environment variables, not as configuration
> options. You could also try setting time_zone system variable with
> set @@time_zone=GMT.