database►Mysql►mysql grant

mysql grant

只读账号

1
2
3
mysql> GRANT SELECT ON *.* TO 'readonly'@'%' IDENTIFIED BY "123456";
mysql> GRANT SELECT ON *.* TO 'readonly'@'%' IDENTIFIED BY "123456";
mysql> flush privileges;

撤销账号

1
2
mysql> revoke insert,update ON user.test from 'readonly'@'%';
mysql> flush privileges;

mysql授权

1
2
mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;  
mysql> flush privileges;

删除权限

1
2
3
4
mysql> revoke all on *.* from ssproot@'10.0.2.111';
mysql> FLUSH   PRIVILEGES;
mysql> delete from mysql.user where user='ssproot' and host='10.0.2.111' ;
mysql> FLUSH   PRIVILEGES;