Why is mysql server time wrong?

Question

I issue the following command on the server:

> date
Mon Mar  9 08:16:02 EDT 2015

Then I log into mysql and type the following:

SELECT @@SYSTEM_TIME_ZONE, @@TIME_ZONE, NOW();

Result:

+--------------------+-------------+---------------------+
| @@SYSTEM_TIME_ZONE | @@TIME_ZONE | NOW()               |
+--------------------+-------------+---------------------+
| EST                | SYSTEM      | 2015-03-09 02:10:00 |
+--------------------+-------------+---------------------+

How can I set the time to be correct?

EDIT: It is not just the hours that is off it is also minutes too.

http://stackoverflow.com/questions/930900/how-to-set-time-zone-of-mysql — pee2pee, Mar 09 '15 at 12:20

score 1 · Answer 1 · edited May 23 '17 at 12:14

1

In your /etc/mysql/mysql.conf or wherever it is, check out the default-time-zone

Reference

edited May 23 '17 at 12:14

Community

1
1

answered Mar 09 '15 at 12:22

Sarath

2,318
1
12
24

It is not in that location on my server, so I'm trying to find it. I will update when it finds something. – AllisonC Mar 09 '15 at 12:54
1

It was located at /etc/my.cnf and the value is: default-time-zone = '+00:00' – AllisonC Mar 09 '15 at 13:47

score 0 · Accepted Answer · answered Apr 22 '15 at 14:12

0

The server date/time was off and mysql was using that as the value. I changed it using the following command:

date -s 'YYYY-MM-DD HH:MM-SS'

Example:

date -s '2015-04-22 10:12-00'

To verify, go into mysql and type:

SELECT NOW()

answered Apr 22 '15 at 14:12

AllisonC

2,973
4
29
46

Why is mysql server time wrong?

2 Answers2