how to set mysql sever date/time.

[lcs01]

The serer time in my mysql is messed up:

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2006-12-07 16:14:19 |
+---------------------+
1 row in set (0.00 sec)

The actual real time right now in my time zone is:

% date
Thu Dec  7 15:21:51 EST 2006

Could someone tell me how to reset my mysql's server time?

Thanks.

 

[hvass]

Date and time come from the server and there is full support for different time zones.

http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html

Looks a bit odd I am not aware of a time zone that is 53 minutes out!

% date
Thu Dec 7 15:21:51 EST 2006

Are you sure this is the time as reported by the server on which mysql is running