Mysql 运维相关

权限相关

grant all privileges on aaaa.table_bbb to test@'%' identified by 'd1233';

查看所有权限：
SELECT user, host,select_priv, insert_priv, update_priv,delete_priv from mysql.user;
查看某人权限:
show grants for'jack'@'%';

回收权限：
revoke all on *.* from 'xiaog' @'%';

数据灌入导出

mysqldump -uroot -h127.0.0.1 -ppasswd  --set-gtid-purged=OFF --force --lock-tables=false 
--databases tmp_database --tables test_table 
| sudo tee test.sql

查询执行的命令,show processlist过滤

select * from information_schema.processlist where Command != 'Sleep';