概述
今天主要分享一个开源的MYSQL数据库SQL语句审核平台--Yearning,提供数据库字典查询,查询审计,SQL审核等多种功能。下面基于docker环境来部署。
环境:
os:CentOS Linux release 7.4.1708 (Core)docker:Docker version 19
一、环境准备
1、关闭防火墙
systemctl stop firewalldsystemctl disable firewalld
2、关闭selinux
setenforce 0sed -i 's/enforcing/diabled/g' /etc/selinux/config
3、配置yum
for i in /etc/yum.repos.d/*.repo;do cp $i ${i%.repo}.bak;donerm -rf /etc/yum.repos.d/*.repowget -P /etc/yum.repos.d/ http://mirrors.aliyun.com/repo/Centos-7.repo >/dev/null 2>&1yum clean all && yum makecache
![6bc0c44d997714029be10355f4d7b0a8.png](https://i-blog.csdnimg.cn/blog_migrate/e73fbcc9dcec76bd1f7e2ef494f7da98.jpeg)
二、准备docker环境
1、卸载老的docker
yum remove docker docker-client docker-client-latest docker-common docker-latest docker-latest-logrotate docker-logrotate docker-engine
![749704504bd49c74c720d56298fd6f8b.png](https://i-blog.csdnimg.cn/blog_migrate/c7a8d69c5e05aff801a46f177bc19a2a.jpeg)
2、安装依赖包
yum install -y yum-utils device-mapper-persistent-data lvm2
![85246d253298d415cf82a5d06af259f5.png](https://i-blog.csdnimg.cn/blog_migrate/3a88af71171c38e7008557b9ee8a8a3e.jpeg)