Mysql5.7错误日志时间不对的解决办法-创新互联

 MySQL 5.7的错误日志时间和系统时间不一致，看起来费劲，查阅官方文档得知从MySQL 5.7.2 开始，新增了 log_timestamps 参数，它主要是控制 error log、genera log等日志文件的显示时间参数:
官文如下：
_{This variable controls the timestamp time zone of error log messages, and of general query log and slow query log messages written to files. It does not affect the time zone of general query log and slow query log messages written to tables (mysql.general_log, mysql.slow_log). Rows retrieved from those tables can be converted from the local system time zone to any desired time zone with CONVERT_TZ() or by setting the session time_zone system variable.}

创新互联是专业的龙泉驿网站建设公司，龙泉驿接单;提供成都网站建设、网站设计,网页设计,网站设计,建网站,PHP网站建设等专业做网站服务;采用PHP框架,可快速的进行龙泉驿网站开发网页制作和功能扩展;专业做搜索引擎喜爱的网站,专业的做网站团队,希望更多企业前来合作!

_{Permitted log_timestamps values are UTC (the default) and SYSTEM (local system time zone).}

_{Timestamps are written using ISO 8601 / RFC 3339 format: YYYY-MM-DDThh:mm:ss.uuuuuu plus a tail value of Z signifying Zulu time (UTC) or ±hh:mm (an offset from UTC).}

_{This variable was added in MySQL 5.7.2. Before 5.7.2, timestamps in log messages were written using the local system time zone by default, not UTC. If you want the previous log message time zone default, set log_timestamps=SYSTEM.
做了如下修改后，显示正常了：}

点击(此处)折叠或打开

当前文章：Mysql5.7错误日志时间不对的解决办法-创新互联
本文来源：http://shouzuofang.com/article/cdpjoj.html