Sorry for the repost, I just want to make sure this didn't go unnoticed.
I'm having trouble on one of my SQL servers. It is the slave in a
master/slave setup. select now() returns the wrong time (+5 hours).
The systems time is in EST and "show variables" shows timezone=EST. This
has been very tr
I'm having trouble on one of my SQL servers. It is the slave in a
master/slave setup. select now() returns the wrong time (+5 hours).
The systems time is in EST and "show variables" shows timezone=EST.
Eg.
mysql> select now();
+-+
| now() |
+---