mysql 許可權管理

標籤：rom   撤銷   use   許可權   sel   user   date   drop   mysq   

1.建立使用者

CREATE USER ‘dingyingsi‘@‘localhost‘ IDENTIFIED BY ‘dys123‘; //將該使用者建立在本機上CREATE USER ‘dingyingsi‘@‘%‘ IDENTIFIED BY ‘dys123‘;　　//建立的使用者可以遠端連線本機

2.授權

grant select,insert,update,delete,create,drop on dys.tb1 to ‘dingyingsi‘@‘localhost‘ identified by ‘dys123‘;grant all privileges on dys.tb1 to ‘dingyingsi‘@‘localhost‘ identified by ‘dys123‘;
grant all privileges on *.* to ‘dingyingsi‘@‘localhost‘ identified by ‘dys123‘;

3.撤銷許可權

revoke all privileges on *.* from [email protected]"%";  revoke all on db1.tb1 from [email protected]"%";  revoke all on db1.* from [email protected]"%";  

 

mysql 許可權管理