Debian Codegraph @

mysql-test/suite/rpl/t/grant_replication_slave.test

raw
1 --echo #
2 --echo # MDEV-21743 Split up SUPER privilege to smaller privileges
3 --echo #
4
5 # Checking that REPLICATION SLAVE is enough to start replication
6
7 create user rpl@localhost;
8 grant replication slave on *.* to rpl@localhost;
9
10 source include/master-slave.inc;
11 connection slave;
12 stop slave;
13 change master to master_user='rpl';
14 connection master;
15
16 create database mysqltest1;
17 create table mysqltest1.t1 (a int);
18 insert mysqltest1.t1 values (1),(2),(3);
19 select * from mysqltest1.t1;
20 flush tables;
21 create user foo@localhost;
22 grant select on *.* to foo@localhost;
23
24 connection slave;
25 start slave;
26 connection master;
27 sync_slave_with_master;
28 select * from mysqltest1.t1;
29 show grants for foo@localhost;
30 connection master;
31 drop user foo@localhost;
32 drop database mysqltest1;
33 sync_slave_with_master;
34 stop slave;
35 change master to master_user='root';
36 source include/start_slave.inc;
37
38 source include/rpl_end.inc;
39 drop user rpl@localhost;