summaryrefslogtreecommitdiff
path: root/mysql-test/suite/roles/set_default_role_ps-6960.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/roles/set_default_role_ps-6960.result')
-rw-r--r--mysql-test/suite/roles/set_default_role_ps-6960.result3
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/suite/roles/set_default_role_ps-6960.result b/mysql-test/suite/roles/set_default_role_ps-6960.result
index c186e7bccb0..505861e89df 100644
--- a/mysql-test/suite/roles/set_default_role_ps-6960.result
+++ b/mysql-test/suite/roles/set_default_role_ps-6960.result
@@ -1,3 +1,4 @@
+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;
@@ -6,4 +7,4 @@ execute stmt;
set password = '';
set default role NONE;
drop role r1;
-update mysql.user set plugin='';
+update mysql.global_priv set priv=@root_priv where user='root' and host='localhost';