Last Month Faced an Issue on one of MySQL DB
Server. System Date was showing wrong while System time was correct. I compared
both time like below:
In application MySQL was throwing wrong date, after
digging I run below query which I fond from fortrabbit.com
SELECT @@global.time_zone, @@session.time_zone;
SYSTEM
SELECT @@system_time_zone;
India Standard Time
Finally I found Time Zone of Windows System
Time was china and MySQL time was still Indian Standard Time and previously
windows system time was changed without re-starting MySQL Services so it was
showing Indian Standard time.
Issue resolved just Re-starting MySQL Server Service..
Happy Reading.
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757