Debian Codegraph @

mysql-test/suite/rpl/r/grant_replication_slave.result

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