SQL学习记录（四）-DCL语句

#DCL
--创建用户itcast，只能够在当前主机localhost访问，密码123456;
CREATE USER 'itcast'@'localhost' IDENTIFIED by '123456';

--创建用户 heima ，可以在任意主机访问该数据库，密码123456;
CREATE user 'heima'@'%' IDENTIFIED by '123456';

--修改用户 heima 的访问密码为 1234;
ALTER USER 'heima' IDENTIFIED with mysql_native_password by '1234';

--删除itcast@localhost用户
DROP USER 'itcast'@'localhost';


--查询权限
show GRANTS FOR 'heima'@'%';

--授予权限
grant all on itcast.* to 'heima'@'%'; # *.*授予所有权限

--撤销权限
REVOKE ALL on itcast.* FROM 'heima'@'%';