MySQL 管理与权限管理

SHOW DATABASES ;
SHOW TABLES FROM mysql ;
USE mysql
#授权表
SELECT * FROM USER ;
SELECT * FROM db;
SELECT * FROM HOST ;
SELECT * FROM tables_priv;
SELECT * FROM columns_priv ;
##用户权限设置，直接复制
#此用户可以复制权限给其他用户
GRANT ALL  PRIVILEGES ON db.tables TO USER@IP IDENTIFIED BY 'password' GRANT OPTIONS ;
#少量权限
GRANT SELECT ,INSERT *.* TO USER@localhost IDENTIFIED BY 'songjia' ;
#删除权限
REVOKE SELECT vulnserve.* FROM USER@localhost ;
#删除用户
DROP USER USER@locahost ;
#立即生效
FLUSH PRIVILEGES ;

#查看用户权限
SHOW GRANTS FOR root@localhost ;

转载于:https://my.oschina.net/u/1169736/blog/525059