mysql之审计

###################

https://blog.csdn.net/weihaodong0557/article/details/113805838

 

 show variables like 'have%';    //查看hava_openssl

 

mkdir /home/work/mysql_3306/ssl/

/home/work/mysql_3306/bin/mysql_ssl_rsa_setup --datadir=/home/work/mysql_3306/ssl

vi my-3308.cnf

[mysqld]

ssl-ca=/home/work/mysql_3306/ssl/ca.pem
ssl-cert=/home/work/mysql_3306/ssl/server-cert.pem
ssl-key=/home/work/mysql_3306/ssl/server-key.pem

 

show variables like 'ver%';   // 查看版本信息

show variables like 'wait%';    //查看登录超时时间

show variables  like  'gener%';   //查看日志是否开启

show variables like  'validate_password%';    //查看是否有密码复杂度插件

install plugin validate_password soname 'validate_password.so';

uninstall  plugin validate_password;

use mysql;     //查询数据库表之前需登录到数据库

select * from user \G;    //查看user表

show databases;

show tables;

 

 

 

 

 

 

 

 

 

 

 

#####################