Mysql5.7錯(cuò)誤日志時(shí)間不對(duì)的解決辦法

 MySQL 5.7的錯(cuò)誤日志時(shí)間和系統(tǒng)時(shí)間不一致，看起來費(fèi)勁，查閱官方文檔得知從MySQL 5.7.2 開始，新增了 log_timestamps 參數(shù)，它主要是控制 error log、genera log等日志文件的顯示時(shí)間參數(shù):
官文如下：
_{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.}

創(chuàng)新互聯(lián)堅(jiān)持“要么做到，要么別承諾”的工作理念，服務(wù)領(lǐng)域包括：網(wǎng)站建設(shè)、成都網(wǎng)站建設(shè)、企業(yè)官網(wǎng)、英文網(wǎng)站、手機(jī)端網(wǎng)站、網(wǎng)站推廣等服務(wù)，滿足客戶于互聯(lián)網(wǎng)時(shí)代的醴陵網(wǎng)站設(shè)計(jì)、移動(dòng)媒體設(shè)計(jì)的需求，幫助企業(yè)找到有效的互聯(lián)網(wǎng)解決方案。努力成為您成熟可靠的網(wǎng)絡(luò)建設(shè)合作伙伴！

_{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).}

<sub>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.

做了如下修改后，顯示正常了：</sub>

本文題目：Mysql5.7錯(cuò)誤日志時(shí)間不對(duì)的解決辦法
分享路徑：http://m.jiaotiyi.com/article/jciigp.html