mysql操作命令
2016-06-12 本文已影响17人
三两五
//取消某个用户的授权
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';