summaryrefslogtreecommitdiff
path: root/mysql-test/suite/roles/set_default_role_ps-6960.result
blob: c186e7bccb0393f1168219ccae2cca839cf9bbb6 (plain)
1
2
3
4
5
6
7
8
9
create role r1;
prepare stmt from "set password = '11111111111111111111111111111111111111111'";
execute stmt;
prepare stmt from "set default role r1";
execute stmt;
set password = '';
set default role NONE;
drop role r1;
update mysql.user set plugin='';