I use this in my.cnf (along with mysqld_multi settings fwiw) and it works great (mysql version 4.0.X): [mysqld_safe] timezone = GMT
It depends on how you start up mysqld.. If you don't use mysqld_safe, the above wont work for you. Atle - 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. > > Petr > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]