概述
今天主要分享一个开源的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
二、准备docker环境
1、卸载老的docker
yum remove docker docker-client docker-client-latest docker-common docker-latest docker-latest-logrotate docker-logrotate docker-engine
2、安装依赖包
yum install -y yum-utils device-mapper-persistent-data lvm2