MySQL社区版本没有自带审计功能，所以基于MySQL8.0.33版本容器运行的MySQL自行安装插件

 因为MySQL社区版本没有自带审计功能，所以基于MySQL8.0.33版本容器运行的MySQL自行安装插件

1.查看Mysql是否安装过audit_log插件

SELECT * FROM information_schema.PLUGINS WHERE PLUGIN_NAME LIKE '%audit%';

 

2.下载Percona Server for MySQL，地址为 Install with binary tarballs - Percona Server for MySQL

 

1.  
   tar -xvf Percona-Server-8.0.33-25-Linux.x86_64.glibc2.17-minimal.tar.gz
2.  
   cd Percona-Server-8.0.33-25-Linux.x86_64.glibc2.17-minimal/lib/plugin
3.  
    
4.  
   #复制插件audit_log.so到容器内mysql插件目录
5.  
   docker cp audit_log.so ca92879e02a9:/usr/lib64/mysql/plugin/

3.安装插件

install plugin audit_log soname 'audit_log.so';

 

4.添加配置,在my.cnf中[mysqld]里面添加

1.  
   plugin-load = audit_log.so
2.  
   audit_log_file = /var/lib/mysql/audit.log
3.  
   audit_log_format = JSON
4.  
   audit_log_policy = ALL
5.  
   audit_log_handler = FILE
6.  
   audit_log_rotate_on_size = 1048576

5.重启MySQL容器

docker restart ca92879e02a9