Posts Change Time Zone in MySQL Server
Post
Cancel

Change Time Zone in MySQL Server

Due to some incidence so I learned that MySQL server has its own time zone cofiguration. Following is the way to modify MySQL server’s time according to your need.

First to check the current time MySQL server.

select curtime();

mysql

To config the time, modify /etc/my.cnf and add the variable default-time-zone.
mysql

Save the change, restart MySQL service.
mysql

Re-login to MySQL server and check if server time is changed.
mysql

This post is licensed under CC BY 4.0 by the author.