Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_gtid_grant_as.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 # Case 1: With --partial_revokes
7 [connection master]
8 SET @save_partial_revokes_master = @@global.partial_revokes;
9 SET GLOBAL partial_revokes=ON;
10 [connection slave]
11 SET @save_partial_revokes_slave = @@global.partial_revokes;
12 SET GLOBAL partial_revokes=ON;
13 [connection master]
14 CREATE USER foo;
15 CREATE ROLE r1, r2;
16 GRANT INSERT ON *.* TO r1 WITH GRANT OPTION;
17 REVOKE INSERT ON mysql.* FROM r1;
18 GRANT SELECT ON *.* TO r2 WITH GRANT OPTION;
19 REVOKE SELECT ON mysql.* FROM r2;
20 GRANT r1, r2 TO foo;
21 ALTER USER foo DEFAULT ROLE ALL;
22 CREATE USER u1, u2, u3, u4, u5, u6, u7;
23 GRANT INSERT, SELECT ON *.* TO u1 AS foo WITH ROLE r1, r2;
24 GRANT INSERT, SELECT ON *.* TO u2 AS foo WITH ROLE ALL;
25 GRANT INSERT, SELECT ON *.* TO u3 AS foo WITH ROLE ALL EXCEPT r1;
26 GRANT INSERT, SELECT ON *.* TO u4 AS foo WITH ROLE DEFAULT;
27 GRANT INSERT, SELECT ON *.* TO u5 AS foo WITH ROLE r1;
28 GRANT INSERT, SELECT ON *.* TO u6 AS foo WITH ROLE NONE;
29 GRANT INSERT, SELECT ON *.* TO u7;
30 [connection master]
31 include/rpl_diff.inc
32 include/rpl_diff.inc
33 include/rpl_diff.inc
34 include/rpl_diff.inc
35 include/rpl_diff.inc
36 include/rpl_diff.inc
37 include/rpl_diff.inc
38 [connection slave]
39 include/stop_slave.inc
40 DROP USER u1, u2, u3, u4, u5, u6, u7;
41 DROP ROLE r1, r2;
42 DROP USER foo;
43 RESET MASTER;
44 RESET SLAVE;
45 Warnings:
46 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
47 [connection slave]
48 include/start_slave.inc
49 include/rpl_diff.inc
50 include/rpl_diff.inc
51 include/rpl_diff.inc
52 include/rpl_diff.inc
53 include/rpl_diff.inc
54 include/rpl_diff.inc
55 include/rpl_diff.inc
56 [connection master]
57 DROP USER u1, u2, u3, u4, u5, u6, u7;
58 DROP ROLE r1, r2;
59 DROP USER foo;
60 [connection master]
61 SET @@global.partial_revokes = @save_partial_revokes_master;
62 [connection slave]
63 SET @@global.partial_revokes = @save_partial_revokes_slave;
64 include/rpl_reset.inc
65 # Case 2: Without --partial_revokes
66 [connection master]
67 SET @save_partial_revokes_master = @@global.partial_revokes;
68 SET GLOBAL partial_revokes=OFF;
69 [connection slave]
70 SET @save_partial_revokes_slave = @@global.partial_revokes;
71 SET GLOBAL partial_revokes=OFF;
72 [connection master]
73 CREATE USER foo;
74 CREATE ROLE r1, r2;
75 GRANT INSERT ON *.* TO r1 WITH GRANT OPTION;
76 GRANT SELECT ON *.* TO r2 WITH GRANT OPTION;
77 GRANT r1, r2 TO foo;
78 ALTER USER foo DEFAULT ROLE ALL;
79 CREATE USER u1, u2, u3, u4, u5, u6, u7;
80 GRANT INSERT, SELECT ON *.* TO u1 AS foo WITH ROLE r1, r2;
81 GRANT INSERT, SELECT ON *.* TO u2 AS foo WITH ROLE ALL;
82 GRANT INSERT, SELECT ON *.* TO u3 AS foo WITH ROLE ALL EXCEPT r1;
83 GRANT INSERT, SELECT ON *.* TO u4 AS foo WITH ROLE DEFAULT;
84 GRANT INSERT, SELECT ON *.* TO u5 AS foo WITH ROLE r1;
85 GRANT INSERT, SELECT ON *.* TO u6 AS foo WITH ROLE NONE;
86 GRANT INSERT, SELECT ON *.* TO u7;
87 [connection master]
88 include/rpl_diff.inc
89 include/rpl_diff.inc
90 include/rpl_diff.inc
91 include/rpl_diff.inc
92 include/rpl_diff.inc
93 include/rpl_diff.inc
94 include/rpl_diff.inc
95 [connection slave]
96 include/stop_slave.inc
97 DROP USER u1, u2, u3, u4, u5, u6, u7;
98 DROP ROLE r1, r2;
99 DROP USER foo;
100 RESET MASTER;
101 RESET SLAVE;
102 Warnings:
103 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
104 [connection slave]
105 include/start_slave.inc
106 include/rpl_diff.inc
107 include/rpl_diff.inc
108 include/rpl_diff.inc
109 include/rpl_diff.inc
110 include/rpl_diff.inc
111 include/rpl_diff.inc
112 include/rpl_diff.inc
113 [connection master]
114 DROP USER u1, u2, u3, u4, u5, u6, u7;
115 DROP ROLE r1, r2;
116 DROP USER foo;
117 [connection master]
118 SET @@global.partial_revokes = @save_partial_revokes_master;
119 [connection slave]
120 SET @@global.partial_revokes = @save_partial_revokes_slave;
121 include/rpl_end.inc