diff options
Diffstat (limited to 'mysql-test/suite/galera/r/galera_password.result')
| -rw-r--r-- | mysql-test/suite/galera/r/galera_password.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_password.result b/mysql-test/suite/galera/r/galera_password.result new file mode 100644 index 00000000..00ffc1df --- /dev/null +++ b/mysql-test/suite/galera/r/galera_password.result @@ -0,0 +1,24 @@ +connection node_2; +connection node_1; +SHOW VARIABLES LIKE '%password%'; +Variable_name Value +default_password_lifetime 0 +disconnect_on_expired_password OFF +max_password_errors 4294967295 +old_passwords OFF +report_password +strict_password_validation ON +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'; +Grants for user123456@localhost +GRANT USAGE ON *.* TO `user123456`@`localhost` IDENTIFIED BY PASSWORD '*5846CF4D641598B360B3562E581586155C59F65A' +GRANT SELECT, INSERT, UPDATE ON `test`.* TO `user123456`@`localhost` +connection node_2; +SHOW GRANTS FOR 'user123456'@'localhost'; +Grants for user123456@localhost +GRANT USAGE ON *.* TO `user123456`@`localhost` IDENTIFIED BY PASSWORD '*5846CF4D641598B360B3562E581586155C59F65A' +GRANT SELECT, INSERT, UPDATE ON `test`.* TO `user123456`@`localhost` +connection node_1; +DROP USER 'user123456'@'localhost'; |