-- 创建用户
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;