MySQL之DCL(数据控制语言)

-- 创建用户
create user 'guest'@'10.7.17.%' identified by 'Guest.18';

-- 删除用户
drop user 'guest'@'10.7.17.%';

-- 修改用户
-- 8.0版本
create user 'guest'@'10.7.17.%' identified by 'Guest.18';
-- 5.0版本
create user 'guest'@'10.7.17.%' identified
    with mysql_native_password by 'Guest.18';

-- 授权select
grant select on hrs.* to 'guest'@'10.7.17.%';                                                  grant

-- 授权insert
grant insert on hrs.* to 'guest'@'10.7.17.%';

-- 授权insert
grant insert on hrs.* to 'guest'@'10.7.17.%';

grant all privileges on *.* to 'guest'@'10.7.17.%';

grant all privileges on *.* to 'guest'@'10.7.17.%' with grant option;

-- 召回
revoke insert on hrs.* from 'guest'@'10.7.17.%';                                           revoke

-- 让权限立马生效
flush privileges;