北大青鸟深圳嘉华分享MySQL用户管理

1.创建用户
CREATE USER teacher@localhost IDENTIFIED BY ‘123456’;
CREATE USER student IDENTIFIED BY ‘123456’;
2.查看用户
USE mysql;
SELECT * FROM USER;
3.权限管理
3.1.收回“z1”的在所有数据库表上的查询权限
revoke select on . from z1@localhost;
3.2.授予“zl”在test1数据库所有表的查询权限
grant select on test1.* to z1@localhost;
3.3.授予所有数据库的所有权限对teacher用户
grant all privileges on . to teacher@localhost;
3.4.teacher除了对所有数据库有全部权限外 还可以进行授权操作
grant all privileges on . to teacher@localhost with grant option;
grant all privileges on . to z1@localhost identified by ‘123’ with grant option;
3.5.授予student用户对myschool数据库的所有表具有查询和插入权限
注意：需要关闭mysql服务器主机的防火墙
grant select,insert on myschool.T156 to ‘student’@’%’ identified by ‘123456’;
3.6.只授予登录权限对z4用户
grant usage on . to ‘z4’@‘localhost’;
3.7.直接操作权限表进行用户授权
insert into db (host,db,use