用户标识= 用户名+ IP
#为用户dev授权,允许查询architect库下的account表的id和name列 grant SELECT(id,name) on architect.account TO 'dev';
#查看用户dev被赋予的所有权限 show grants for dev;
REVOKE SELECT(id,name) on architect.account TO 'dev';
show variables like '%proxy%';
set GLOBAL check_proxy_users =1; set GLOBAL mysql_native_password_proxy_users = 1;
create USER 'dev_role'
create USER 'rd1'; create USER 'rd2';
grant proxy on 'dev_role' to 'rd1'; grant proxy on 'dev_role' to 'rd2';
show grants from 'rd1';
grant select(id,name) on architect.account to 'dev_role';