mysql社区版审计插件_MySQL之MariaDB启用审计插件

对于MySQL Percona MariaDB三家都有自己的审计插件，但是呢，MySQL的审计插件是只有企业版才有的，同时也有很多第三方的的MySQL的审计插件，而Percona和MariaDB都是GPL的审计插件

首先看一下mariaDB 的审计插件

[root@linuxidc /usr/local/mysql]# mysql -uroot -ppassword

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 42804

Server version: 10.0.14-MariaDB-log Source distribution

Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show variables like '%audit%';

Empty set (0.00 sec)

MariaDB [(none)]> INSTALL PLUGIN server_audit SONAME 'server_audit.so'; #安装审计插件

Query OK, 0 rows affected (0.18 sec)

MariaDB [(none)]> show variables like '%audit%';

+-------------------------------+-----------