Debian Codegraph @

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

raw
1 # Bug#36483690 "ALTER USER" fails in NDB schema distribution
2
3 --source include/have_ndb.inc
4
5 CREATE USER 'nsu1'@'%' IDENTIFIED BY 'xrm0Baa--';
6 GRANT SELECT ON test.* to 'nsu1'@'%';
7 GRANT NDB_STORED_USER ON *.* TO 'nsu1'@'%';
8
9 # Prove that the connections are talking to two different servers
10 disable_query_log;
11 select @@ndb_log_bin;
12 let id1 = `select @@server_id`;
13
14 connect(verifycon,127.0.0.1,nsu1,xrm0Baa--,test,$MASTER_MYPORT1);
15 connection verifycon;
16 let id2 = `select @@server_id`;
17 echo $id1;
18 echo $id2;
19 assert($id1 != $id2);
20 disable_result_log;
21
22 let iter=50;
23 while($iter > 0)
24 {
25 connection default;
26 let $pass=`SELECT concat(char(floor(rand() * 26) + 64 USING latin1),
27 char(floor(rand() * 26) + 96 USING latin1),
28 char(floor(rand() * 26) + 64 USING latin1),
29 char(floor(rand() * 26) + 96 USING latin1),
30 char(floor(rand() * 56) + 35 USING latin1),
31 char(floor(rand() * 56) + 35 USING latin1),
32 char(floor(rand() * 56) + 35 USING latin1),
33 char(floor(rand() * 56) + 35 USING latin1),
34 char(floor(rand() * 56) + 35 USING latin1),
35 char(floor(rand() * 56) + 35 USING latin1),
36 char(floor(rand() * 56) + 35 USING latin1),
37 char(floor(rand() * 56) + 35 USING latin1),
38 "01234567890-") as p`;
39 eval ALTER USER 'nsu1'@'%' IDENTIFIED BY "$pass" RETAIN CURRENT PASSWORD;
40
41 disconnect verifycon;
42 # Connect to the other server using the new password:
43 connect(verifycon,127.0.0.1,nsu1,$pass,test,$MASTER_MYPORT1);
44 connection verifycon;
45 let id = `select @@server_id`;
46 assert($id == $id2);
47
48 dec $iter;
49 }
50
51 # Cleanup
52 disconnect verifycon;
53
54 connection default;
55 DROP USER 'nsu1'@'%';
56