查看用户的授权
SHOW GRANTS FOR guest@'%';
删除用户的授权
REVOKE DELETE ON passdb.* FROM 'guest'@'%';
FLUSH PRIVILEGES;
远程授权
GRANT select ON test_paas.* TO 'guest'@'%' IDENTIFIED BY 'zbxtestuser2019' WITH GRANT OPTION;
flush privileges;
SHOW GRANTS FOR guest@'%';
REVOKE DELETE ON passdb.* FROM 'guest'@'%';
FLUSH PRIVILEGES;
GRANT select ON test_paas.* TO 'guest'@'%' IDENTIFIED BY 'zbxtestuser2019' WITH GRANT OPTION;
flush privileges;
本文标题:远程授权
本文链接:https://www.haomeiwen.com/subject/emxngctx.html
网友评论