安装rsyslog-mysql包

yum install rsyslog-mysql

rpm -ql rsyslog-mysql

将mysql- createDB.sql发送到远程接收端

scp /usr/share/doc/rsyslog-8.24.0/mysql-createDB.sql 192.168.30.17:/root/

切换到远程接收端：

导入数据库

mysql < mysql-createDB.sql

mysql > use Syslog

mysql > show tables;

创建一个syslog授权用户

mysql > grant all on Syslog.* to syslog@’192.168.30.%’ identified by ‘centos’;

musql > flush privileges;