mysql基线检查_数据库基线检查

history | grep -i mysql
netstat -nplv

ps -aux | grep -i mysql

mysql -h IP -u 用户名 -p

STATUS;
SELECT host,user,authentication_string,password_lifetime,password_expired FROM mysql.user;
SHOW variables LIKE ‘validate_password%’;
SHOW variables LIKE “%max_connect_errors%”;
SHOW variables LIKE ‘connection-control%’;
SHOW variables LIKE ‘%timeout’;
SHOW variables LIKE ‘%ssl%’;
SELECT user,ssl_type,ssl_cipher FROM mysql.user;

SELECT user , host , Select_priv , Insert_priv , Update_priv , Delete_priv , Create_priv , Drop_priv , Reload_priv , Shutdown_priv , Process_priv , File_priv , Grant_priv , References_priv , Index_priv , Alter_priv , Show_db_priv , Super_priv , Create_tmp_table_priv , Lock_tables_priv , Execute_priv , Repl_slave_priv , Repl_client_priv , Create_view_priv , Show_view_priv , Create_routine_priv , Alter_routine_priv , Create_user_priv , Event_priv , Trigger_priv , Create_tablespace_priv FROM mysql.user;

SELECT * FROM mysql.db;
SELECT * FROM mysql.Tables_priv;
SELECT * FROM mysql.Columns_priv;
SHOW variables LIKE ‘%log%’;

SELECT user , host , Select_priv , Insert_priv , Update_priv , Delete_priv , Create_priv , Drop_priv , Reload_priv , Shutdown_priv , Process_priv , File_priv , Grant_priv , References_priv , Index_priv , Alter_priv , Show_db_priv , Super_priv , Create_tmp_table_priv , Lock_tables_priv , Execute_priv , Repl_slave_priv , Repl_client_priv , Create_view_priv , Show_view_priv , Create_routine_priv , Alter_routine_priv , Create_user_priv , Event_priv , Trigger_priv , FROM mysql.user;

select * from mysql.user;