Forum Stats

  • 3,852,530 Users
  • 2,264,112 Discussions


MySQL v5.7.18 time stamp and time zone problem

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