-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 21, 2005 08:55
To: mysql@lists.mysql.com
Subject: Timezone setting wrong?
I've got a RHEL3 server I just installed with mysql 4.0.16.
The hardware clock and system clock are both set to UTC and
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
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