用户的创建

create user "yanzhao1"@"localhost" identified by "2019210902";

create user "yanzhao2"@"localhost" identified by "2019210902";

create user "yanzhao3"@"localhost" identified by "2019210902";

create user "yanzhao4"@"localhost" identified by "2019210902";
grant select,insert,update on *.* to "yanzhao4"@"localhost";

用户授权

• 授予第一个用户为数据库级用户，对 dreamhom 拥有所有权

grant all on dreamhom.* to “yanzhao1”@”localhost”;

• 授予第二个用户为表级用户，对dreamhom中的staff 表具有select，insert,delete 权限

grant select,insert,delete on dreamhom.staff to “yanzhao2”@”localhost”;

• 授予第三个用户为列级用户，对 dreamhom 中的 staff 表的 fname列以及 lname 拥有 select 权限

grant select(fname,lname) on dreamhom.staff to “yanzhao3”@”localhost”;

权限回收

revoke select on *.* from "yanzhao4"@"localhost";

删除用户

drop user "yanzhao4"@"localhost";