# mv /etc/localtime /etc/localtime.bk
# ln -s /usr/share/zoneinfo/Requiredtimezone /etc/localtime
After this you need to restart mysql to correct mysql time. Steps to check mysql and server time are correct
# date +%s
1332653030
# mysql
SELECT FROM_UNIXTIME(1332653030);
Check if above time and date time matches
No comments:
Post a Comment