mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 04:46:15 +01:00
23 lines
562 B
Text
23 lines
562 B
Text
connection node_2;
|
|
connection node_1;
|
|
#
|
|
# MDEV#6266: Changing password fails on galera cluster
|
|
#
|
|
|
|
# On node_1
|
|
connection node_1;
|
|
GRANT SELECT ON *.* TO 'user_6266'@'localhost' IDENTIFIED BY 'pass';
|
|
|
|
# Now, try changing password for 'user_6266'. This command should also
|
|
# execute successfully on the other node.
|
|
SET PASSWORD FOR 'user_6266'@'localhost' = PASSWORD('newpass');
|
|
|
|
# On node_2
|
|
connection node_2;
|
|
SELECT user FROM mysql.user WHERE user='user_6266';
|
|
User
|
|
user_6266
|
|
DROP USER 'user_6266'@'localhost';
|
|
disconnect node_2;
|
|
disconnect node_1;
|
|
# End of test
|