How to change MySQL Server timezone?

If you have multiple SQL Server instances for different zone in that server. You can set the timezone differently for each instance using the following method.

Log in as root or similarly high-privileged user, to run this query.

SET GLOBAL time_zone = '-00:00';

In the above query, I am setting the SQL server time zone to UTC i.e., GMT.

Yes, there’s a negative zero. And it has to be a negative zero or a positive one, otherwise it won’t work.

Resources

Official SQL Timezones

Last Updated on Feb 11, 2020