dd

MySQL 安全检查

select user, host FROM mysql.user;
show variables like 'validate%';
show variables like '%password%';
show variables like '%general%';
show variables like 'general_log%';
show variables like '%control%'；
show variables like '%connection_control%';
show variables like '%timeout%';
show variables like '%ssl%';
show variables like '%have_ssl%';
show variables like '%have_openssl%';

-- 查看XXXX管理员权限
show grants for 'XXXX'@'localhost';
select user,authentication_string from mysql.user;
select username,account_status from dba_users；

-- 查看用户角色权限
select * from mysql.user where user='用户名'；
select * from mysql.db;
select * from mysql.tables_priv;
select * from mysql.columns_priv;
Show variables like '%log%';

select * from information_schema.PLUGINS where PLUGIN_NAME='audit_log';

select version();
show variables where variable_name like 'version';
show variables where variable_name like '%version%';

数据库具体备份策略:截图