GRANT SELECT ON *.* TO 'readonly'@'%' IDENTIFIED BY "password";
flush privileges;
OK!
如果需要针对某个库或某个库下的某个表增加权限
GRANT all privileges ON user.* TO 'readonly'@'%';//针对user库下的所有表增加所有权限
or
GRANT insert,update ON user.test TO 'readonly'@'%';针对user库下的test表增加insert和update权限
flush privileges;
OK!
如果需要撤销权限,就把grant换成revoke,to换成from,identified by xxx去掉,其他完全一样
revoke insert,update ON user.test from 'readonly'@'%';
flush privileges;
OK!