本文详细介绍如何在MySQL中使用REVOKE和GRANT命令精确控制用户wuzg对特定数据库和表的SELECT权限，包括撤销和授予操作，以及查看wuzg用户的权限列表。
revoke SELECT ON `open`.`admins` from wuzg;
revoke SELECT ON *.* from wuzg;
show GRANTS for wuzg;
GRANT SELECT ON open.admins TO 'wuzg'@'%'
转载于:https://www.cnblogs.com/agang-php/p/11507116.html
授权某个数据库某个表权限
revoke SELECT ON `open`.`admins` from wuzg;
revoke SELECT ON *.* from wuzg;
show GRANTS for wuzg;
GRANT SELECT ON open.admins TO 'wuzg'@'%'
转载于:https://www.cnblogs.com/agang-php/p/11507116.html
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
