本文共 845 字,大约阅读时间需要 2 分钟。
grant 权限 on 数据库对象 to 用户
grant 权限 on 数据库对象 to 用户 identified by “密码”grant all on . to ad@‘%’ identified by “ad_pass”;
grant all on . to ad@’192.168.0.10’ identified by “ad_pass”;
grant all privileges on test to ad@’192.168.0.10’ identified by “ad_pass”;
或 grant all on test to ad@’192.168.0.10’ identified by “ad_pass”;grant all on test.table1 to ad@’192.168.0.10’ identified by “ad_pass”
grant select(id,se,rank) on test.table1 to ad@’192.168.0.10’ identified by “ad_pass”;
grant select,insert,update,delete on test.* to ad@’192.168.0.10’ identified by “ad_pass”;
revoke all on . from ad@localhost;
show grants;
show grants for ad@localhost;转载地址:http://udcqi.baihongyu.com/