Debian Codegraph @

mysql-test/suite/ndb/t/stored_grants_val_pass.test

raw
1 # BUG #99859 NDB_STORED_USER + validate_password component
2
3 --source include/have_ndb.inc
4 --source include/have_validate_password_component.inc
5
6 connect(mysqld2,127.0.0.1,root,,test,$MASTER_MYPORT1);
7 connection mysqld2;
8 INSTALL COMPONENT "file://component_validate_password";
9
10 connection default;
11 INSTALL COMPONENT "file://component_validate_password";
12
13 # Create user ndb_u1 on mysql1
14 CREATE USER 'ndb_u1'@'localhost' IDENTIFIED by '123_Strong_Password_321';
15 GRANT NDB_STORED_USER ON *.* to 'ndb_u1'@'localhost';
16
17 # Connect to mysql2 as user ndb_u1
18 connect (test_u1,127.0.0.1,ndb_u1,123_Strong_Password_321,,$MASTER_MYPORT1);
19
20 # Cleanup
21 #
22 connection default;
23 DROP USER 'ndb_u1'@'localhost';
24 UNINSTALL COMPONENT "file://component_validate_password";
25
26 connection mysqld2;
27 UNINSTALL COMPONENT "file://component_validate_password";
28
29