Resetting the Default Time Zone

[Ricky158]

Whenever I timestamp something with MySQL's NOW() function or if the field is ON UPDATE CURRENT_TIMESTAMP, the time zone of it ends up being set to Central time. I (and most of my users) use the Eastern time zone. Instead of even beginning to consider manually "+1" to the hour every time I need to look at the timestamps, is there a way to just reset the configuration of my database to Eastern? I checked and I don't have SUPER permissions, whatever that means.


SET time_zone = 'US/Eastern'

#1298 - Unknown or incorrect time zone: 'US/Eastern'


Any ideas?