[Novalug] MySQL time does not match system time

[Mike McFadden]

Hi All,

I have searched and searched the internet for a solution to this problem with no luck and I'm stuck. I am running SuSE 10 and I reset the time when we went to daylight time. It is correct now:

linux:/home/mike # date
Tue Apr  6 13:28:25 EDT 2010


However MySQL which I thought uses the system time is using EST and thus is wrong:

mysql> SELECT CURTIME();
+-----------+
| CURTIME() |
+-----------+
| 12:28:12  |
+-----------+
1 row in set (0.00 sec)

The MySQL variables are 

| system_time_zone                | EST                        |
| time_zone                       | SYSTEM                     |

Do I need to change the system date/time in more than one place (I made the change through KDE)? This is the error I get when I try to change it directly in MySQL:

mysql> set system_time_zone='EDT';
ERROR 1193 (HY000): Unknown system variable 'system_time_zone'

I have been using Liunx/MySQL/Apache for a long time, but I am far from an expert. Any advice is greatly appreciated.

Thanks,
Mike 


Michael S. McFadden
Electronic Publishing Systems Department
American Geophysical Union
2000 Florida Avenue, NW
Washington, DC 20009

e: mmcfadden at agu.org
v: 202.777.7527
f: 202.777.7385