//取消某个用户的授权
REVOKE ALL PRIVILEGES ON . FROM 'cpwx'@'%';
//给某个用户授权
grant ALL PRIVILEGES ON db_name.* to 'username'@'%' identified by 'password';
//取消某个用户的授权
REVOKE ALL PRIVILEGES ON . FROM 'cpwx'@'%';
//给某个用户授权
grant ALL PRIVILEGES ON db_name.* to 'username'@'%' identified by 'password';
本文标题:mysql操作命令
本文链接:https://www.haomeiwen.com/subject/mmoedttx.html
网友评论