记录mysql 使用role赋予user权限

create role "zdkall"  创建角色租

grant all privileges  on  *.*  to 'zdkall';  赋予角色租权限

create user "zdklngchen1"@"%"  identified by "zdklngchen1";     创建用户

grant zdkall to zdklngchen1;  把用户加入组

set default role all to zdklngchen1;  给组内用户设置组的权限