Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 SHOW VARIABLES LIKE '%password%';
4 Variable_name Value
5 default_password_lifetime 0
6 disconnect_on_expired_password OFF
7 max_password_errors 4294967295
8 old_passwords OFF
9 report_password
10 strict_password_validation ON
11 CREATE USER 'user123456'@'localhost';
12 GRANT SELECT, INSERT, UPDATE ON test.* TO 'user123456'@'localhost';
13 SET PASSWORD FOR 'user123456'@'localhost' = PASSWORD('A$10abcdDCBA123456%7');
14 SHOW GRANTS FOR 'user123456'@'localhost';
15 Grants for user123456@localhost
16 GRANT USAGE ON *.* TO `user123456`@`localhost` IDENTIFIED BY PASSWORD '*5846CF4D641598B360B3562E581586155C59F65A'
17 GRANT SELECT, INSERT, UPDATE ON `test`.* TO `user123456`@`localhost`
18 connection node_2;
19 SHOW GRANTS FOR 'user123456'@'localhost';
20 Grants for user123456@localhost
21 GRANT USAGE ON *.* TO `user123456`@`localhost` IDENTIFIED BY PASSWORD '*5846CF4D641598B360B3562E581586155C59F65A'
22 GRANT SELECT, INSERT, UPDATE ON `test`.* TO `user123456`@`localhost`
23 connection node_1;
24 DROP USER 'user123456'@'localhost';