Hi,

I am using these lines in my.cnf at [mysqld_safe] section.

[mysqld_safe]
timezone = GMT

It works fine for me.

Best regards,
Mikhail.

----- Original Message ----- 
From: "Juan Antonio Ruiz Zwollo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 13, 2003 5:38 PM
Subject: Setting the timezone


> Hi.
>
> I am trying to change the timezone for MySQL (version 3.23.56) but it does
> not seem to work.
>
> Currently the timezone is set to "MDT" (I think its the default for
MySQL).
>
> I added the following line to /etc/my.cnf at the [mysqld] section:
> set-variable   = timezone=CST
>
> But when I try to stop and start the daemon, it does not want to start:
> ---------------------------------------
> Starting mysqld daemon with databases from /usr/local/mysql/var
> 031013 10:04:04  mysqld ended
> ---------------------------------------
>
> It will only start if I remove the timezone line from my.cnf, but then the
> timezone stays at MDT.
>
> Thanks for your time.
>
> Kind regards,
>
>
> Juan Antonio Ruiz Zwollo
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to