Debian Codegraph @

mysql-test/suite/galera/r/grant.result

raw
1 connection node_2;
2 connection node_1;
3 #
4 # MDEV#6266: Changing password fails on galera cluster
5 #
6
7 # On node_1
8 connection node_1;
9 GRANT SELECT ON *.* TO 'user_6266'@'localhost' IDENTIFIED BY 'pass';
10
11 # Now, try changing password for 'user_6266'. This command should also
12 # execute successfully on the other node.
13 SET PASSWORD FOR 'user_6266'@'localhost' = PASSWORD('newpass');
14
15 # On node_2
16 connection node_2;
17 SELECT user FROM mysql.user WHERE user='user_6266';
18 User
19 user_6266
20 DROP USER 'user_6266'@'localhost';
21 disconnect node_2;
22 disconnect node_1;
23 # End of test