MySQL v5.7.18 time stamp and time zone problem

CONCEPT21

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. 

CONCEPT21

Hello Friends,

I find a variable log_timestamps which is set to UTC by default.

I think it can be set to my local time zone. 

Gaz in Oz

What is your time_zone and system_time_zone set to?

For example:

[[email protected] ~]# dateSat May  6 18:49:51 AEST 2017[[email protected] ~]# date -uSat May  6 08:49:56 UTC 2017 [[email protected] ~]# mysql -p -se "SHOW VARIABLES" | grep time_zone
Enter password:system_time_zone        AESTtime_zone       SYSTEM[[email protected] ~]#

Check your settings.

...and read this.

https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html

Cheers,

Gaz.

Dave Stokes-MySQL Community Team-Oracle

what does your 'SHOW VARIABLES LIKE 'SYSTEM_TIME_ZONE''; show?

The relevant man page https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html

Dave Stokes-MySQL Community Team-Oracle

Also check https://dev.mysql.com/doc/refman/5.7/en/mysql-tzinfo-to-sql.html

CONCEPT21

Hello Friends,

I find a variable log_timestamps which is set to UTC by default.

I think it can be set to my local time zone. 

Dave Stokes-MySQL Community Team-Oracle

System time or UTC according to https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_log_timestamps