Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_ignore_grant.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 set sql_mode="";
5 delete from mysql.user where user=_binary'rpl_ignore_grant';
6 delete from mysql.db where user=_binary'rpl_ignore_grant';
7 flush privileges;
8 connection slave;
9 set sql_mode="";
10 delete from mysql.user where user=_binary'rpl_ignore_grant';
11 delete from mysql.db where user=_binary'rpl_ignore_grant';
12 flush privileges;
13 connection master;
14 grant select on *.* to rpl_ignore_grant@localhost;
15 grant drop on test.* to rpl_ignore_grant@localhost;
16 show grants for rpl_ignore_grant@localhost;
17 Grants for rpl_ignore_grant@localhost
18 GRANT SELECT ON *.* TO `rpl_ignore_grant`@`localhost`
19 GRANT DROP ON `test`.* TO `rpl_ignore_grant`@`localhost`
20 connection slave;
21 show grants for rpl_ignore_grant@localhost;
22 ERROR 42000: There is no such grant defined for user 'rpl_ignore_grant' on host 'localhost'
23 select count(*) from mysql.user where user=_binary'rpl_ignore_grant';
24 count(*)
25 0
26 select count(*) from mysql.db where user=_binary'rpl_ignore_grant';
27 count(*)
28 0
29 grant select on *.* to rpl_ignore_grant@localhost;
30 connection master;
31 set password for rpl_ignore_grant@localhost=password("does it work?");
32 connection slave;
33 select password<>_binary'' from mysql.user where user=_binary'rpl_ignore_grant';
34 password<>_binary''
35 0
36 connection master;
37 delete from mysql.user where user=_binary'rpl_ignore_grant';
38 delete from mysql.db where user=_binary'rpl_ignore_grant';
39 flush privileges;
40 connection slave;
41 delete from mysql.user where user=_binary'rpl_ignore_grant';
42 delete from mysql.db where user=_binary'rpl_ignore_grant';
43 flush privileges;
44 connection master;
45 include/rpl_end.inc