Forum Stats

  • 3,854,212 Users
  • 2,264,340 Discussions
  • 7,905,609 Comments

Discussions

MySQL v5.7.18 time stamp and time zone problem

CONCEPT21
CONCEPT21 Member Posts: 72 Red Ribbon
edited May 12, 2017 8:47AM in MySQL Community Space

Hello!  It is me again!

I have 2 installations of MySQL v5.7.18.  One is on Oracle Linux 7.3 and the other is on Ubuntu 16.04.

Both of their mysql log records show time stamp in GMT (UTC).  I have checked my system OS's time zone setting and they are set correctly to my local time zone GMT+8.

So how do I make the mysql log records being shown in my local time zone?  In the older version of mysql, their log records were shown in my local time zone.

Hope to hear your helpful opinion. 

Best Answer

Answers