MySQL权限

#为用户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';