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.
To config the time, modify
/etc/my.cnf and add the variable
Save the change, restart MySQL service.
Re-login to MySQL server and check if server time is changed.