mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
![Jan Lindström](/assets/img/avatar_default.png)
Problem was that we should skip strict password validation on applier nodes similarly as is done for slave nodes.
14 lines
418 B
Text
14 lines
418 B
Text
--source include/galera_cluster.inc
|
|
|
|
SHOW VARIABLES LIKE '%password%';
|
|
|
|
CREATE USER 'user123456'@'localhost';
|
|
GRANT SELECT, INSERT, UPDATE ON test.* TO 'user123456'@'localhost';
|
|
SET PASSWORD FOR 'user123456'@'localhost' = PASSWORD('A$10abcdDCBA123456%7');
|
|
SHOW GRANTS FOR 'user123456'@'localhost';
|
|
|
|
--connection node_2
|
|
SHOW GRANTS FOR 'user123456'@'localhost';
|
|
|
|
--connection node_1
|
|
DROP USER 'user123456'@'localhost';
|