mysql--許可權問題

標籤：mysql   use   insert   creat   flush   lin   any   sql   ant   

#建立使用者
create user ‘lin‘@‘localhost‘ identified by ‘123‘;

#insert,delele,update,select
#層級1：對所有庫，下的所有表，下的所有欄位
grant select on *.* to ‘lin1‘@‘localhost‘ identified by ‘123‘;

#層級2：對db1庫，下的所有表，下的所有欄位
grant select on db1.* to ‘lin2‘@‘localhost‘ identified by ‘123‘;

#層級3：對錶db1.t1，下的所有欄位
grant select on db1.t1 to ‘lin3‘@‘localhost‘ identified by ‘123‘;

#層級4：對錶db1.t1，下的id,name欄位
grant select (id,name) on db1.t1 to ‘lin4‘@‘localhost‘ identified by ‘123‘;
grant select (id,name),update (name) on db1.t1 to ‘lin5‘@‘localhost‘ identified by ‘123‘;

#修改完許可權後，要記得重新整理許可權
flush privileges;

localhost本地主機, identified by以什麼..鑒別
grant 授予,允許. select挑選
create user ‘panyu‘@‘localhost‘ identified by ‘123‘
建立使用者

grant select on *.* to ‘pan‘@‘localhost‘ identified by ‘123‘
授予pan查看所有庫以及所有欄位的許可權
grant select on db1.* to ‘yu‘@‘localhost‘ identified by ‘123‘;
授予yu查看所有該庫下面的所有表的許可權
grant select on db1.t1 to ‘zhuge‘@‘loaclhost‘ identified by ‘123‘;
授予zhuge查看db1庫,下面t1表裡的欄位.
grant select (id,name) on db1.t1 to ‘guanyu‘@‘localhost‘ identified by ‘123‘;
grang select (id,name) update(name) on db1.t1 to ‘zhangfei‘@identified by ‘123‘;

mysql--許可權問題