由于安全审计需要,要将mysql的error log 记录到syslog中。
mysqld_safe –verbose –help|grep syslog
–syslog Log messages to syslog with ‘logger’
–skip-syslog Log messages to error log (default)
–syslog-tag=TAG Pass -t “mysqld-TAG” to ‘logger’
MySQL5.6.24 my.cnf中增加如下配置:
[mysqld_safe]
syslog
skip-syslog=false
syslog-tag=3306
确保rsyslog服务启用
service rsyslog status
rsyslogd (pid 2424) is running..
重启mysql服务,发现如下错误:
mysqld_safe Can’t log to error log and syslog at the same time.
Remove all –log-error configuration options for –syslog to take effect.
注释掉my.cnf中的log_error ,重启mysql服务。
检查/var/log/message已经能看到mysql的启动信息了
tail -f /var/log/message
mysqld_safe-3316: Starting mysqld daemon with databases from
参考文档:
https://dev.mysql.com/doc/refman/5.6/en/mysqld-safe.html#option_mysqld_safe_syslog