mysql-test/suite/galera/t/galera_password.test
raw| 1 | --source include/galera_cluster.inc |
| 2 | |
| 3 | SHOW VARIABLES LIKE '%password%'; |
| 4 | |
| 5 | CREATE USER 'user123456'@'localhost'; |
| 6 | GRANT SELECT, INSERT, UPDATE ON test.* TO 'user123456'@'localhost'; |
| 7 | SET PASSWORD FOR 'user123456'@'localhost' = PASSWORD('A$10abcdDCBA123456%7'); |
| 8 | SHOW GRANTS FOR 'user123456'@'localhost'; |
| 9 | |
| 10 | --connection node_2 |
| 11 | SHOW GRANTS FOR 'user123456'@'localhost'; |
| 12 | |
| 13 | --connection node_1 |
| 14 | DROP USER 'user123456'@'localhost'; |