Debian Codegraph @

mysql-test/suite/galera/t/grant.test

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