MySQL Time Different from System Time

I'm having an issue where MySQL is reporting the time as six minutes later than the system time. I have verified all my timezone settings are correct but don't know how to troubleshoot the six minute difference:

mysql> SELECT NOW(),CURDATE(),CURTIME();
+---------------------+------------+-----------+
| NOW()               | CURDATE()  | CURTIME() |
+---------------------+------------+-----------+
| 2015-04-24 16:05:24 | 2015-04-24 | 16:05:24  |
+---------------------+------------+-----------+
1 row in set (0.00 sec)


[root@server]# clock
Fri 24 Apr 2015 03:59:04 PM UTC  -0.860391 seconds

Thank you!

I hate to state the obvious, but is MySQL running on the same system as the bash instance?

Are you SSHing into the server or is it a local Linux desktop? How are you connecting to MySQL?

I recently had to troubleshoot this exact issue, thus finding this post. In our case the dev was using an alias to connect to MySQL, and he did not remember that MySQL was actually running on a different host than he was SSHing into (also with an alias).

I also encountered the same issue.

In my case, the server's time zone is set to IST but mysql is referring to UTC timezone.

This issue occurred as I haven't restarted mysql after changing the server's time zone.

service mysql restart will work!