how to change database timezone on vps
- by michael
I am running my domain on a vps and I have virtualmin and webmin access.
In my php files, I need to record the current time by using mysql NOW() when a row is inserted.
I changed the timezone from the php configuration on webmin, but the database function NOW() is still using the default timezone.
How can I change the database timezone?
PS: I run mysql command to change timezone on webmin, but it gave me the error:
Failed to execute SQL : SQL SET time_zone = 'America/New_York'; failed : Unknown or incorrect time zone: 'America/New_York'