权限相关
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';