mariadb/mysql-test/suite/roles/set_default_role_ps-6960.result
Sergei Golubchik 4abb8216a0 MDEV-17658 change the structure of mysql.user table
Implement User_table_json.
Fix scripts to use mysql.global_priv.
Fix tests.
2018-12-12 00:31:44 +01:00

10 lines
397 B
Text

select priv into @root_priv from mysql.global_priv where user='root' and host='localhost';
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.global_priv set priv=@root_priv where user='root' and host='localhost';