Edit MySQL timezone

For edit the time zone on your mysql server, you can run the query as below.

SET GLOBAL time_zone = 'timezone';

timezone can be set based on the zone you need. For example your time zone is GMT+0800, then just run the query as below.

SET GLOBAL time_zone = '+800';

For how to check the current time, please refer to here

How to change timezone (Linux server)

How to change your server time zone, I bet everyone know how to edit it on Window server. But for the Linux server, you need to use command as below

Change to GMT

ln -sf /usr/share/zoneinfo/GMT /etc/localtime

Change to EST

ln -sf /usr/share/zoneinfo/EST /etc/localtime