Different times in mysql and the server! How can they be equal?


My server timezone is not matching with mysql timezone.

How to set desired timezone for mysql server?

Asked on October 10, 2018 in Programmer.
Add Comment
1 Answer(s)
Best answer

First access mysql,

mysql -u root -p

it will ask for you password for mysql server, enter password and hit enter

now you are here

mysql >

Now run below command for setting timezone Asia/Kolkata

SET GLOBAL time_zone = "+5:30";
Answered on October 10, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.