Renato,
Tuesday, July 23, 2002, 9:40:35 PM, you wrote:
RL I have several mysql servers installed, all without TZ variable, one of
RL them, insists in set the select now() to 4 hours ahead of my internal
RL clock, first I touch that I should set TZ to my time time zone in
RL /etc/init.d/mysql,
in the redhat instalation procedure. And I did that for all servers, but
only this one has this behaviour.
Egor Egorov wrote:
Renato,
Tuesday, July 23, 2002, 9:40:35 PM, you wrote:
RL I have several mysql servers installed, all without TZ variable, one of
RL them, insists in set the select
Renato,
Thursday, July 25, 2002, 2:35:56 PM, you wrote:
RL in the redhat instalation procedure. And I did that for all servers, but
RL only this one has this behaviour.
Run
safe_mysqld --timezone=America/Manaus
and show me the output of
SHOW VARIABLES LIKE 'timezone'
RL Egor Egorov
I have several mysql servers installed, all without TZ variable, one of
them, insists in set the select now() to 4 hours ahead of my internal
clock, first I touch that I should set TZ to my time time zone in
/etc/init.d/mysql, but when I do that, the select now() advances 4
more hours.