Debian Codegraph @

mysql-test/suite/rpl/r/rpl_priv_checks_user_set_vars.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 #
7 # TC1. Verify that replication only succeeds with
8 # `SYSTEM_VARIABLES_ADMIN` due to the set of `pseudo_thread_id`
9 # ------------------------------------------------------------------
10 #
11 CREATE TABLE t_system (c1 INT);
12 INSERT INTO t_system VALUES (1), (2);
13 [connection slave]
14 CALL mtr.add_suppression(".*you need .at least one of. the SUPER.* SYSTEM_VARIABLES_ADMIN.*");
15 CALL mtr.add_suppression(".*The replica coordinator and worker threads are stopped.*");
16 GRANT REPLICATION_APPLIER, CREATE, INSERT, DROP ON *.* TO 'u1'@'localhost';
17 SHOW GRANTS FOR 'u1'@'localhost';
18 Grants for u1@localhost
19 GRANT INSERT, CREATE, DROP ON *.* TO `u1`@`localhost`
20 GRANT REPLICATION_APPLIER ON *.* TO `u1`@`localhost`
21 START SLAVE;
22 Warnings:
23 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
24 include/wait_for_slave_sql_error.inc [errno=1227]
25 STOP SLAVE;
26 Warnings:
27 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
28 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO 'u1'@'localhost';
29 SHOW GRANTS FOR 'u1'@'localhost';
30 Grants for u1@localhost
31 GRANT INSERT, CREATE, DROP ON *.* TO `u1`@`localhost`
32 GRANT REPLICATION_APPLIER,SYSTEM_VARIABLES_ADMIN ON *.* TO `u1`@`localhost`
33 START SLAVE;
34 Warnings:
35 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
36 [connection master]
37 include/sync_slave_sql_with_master.inc
38 include/diff_tables.inc [master:t_system, slave:t_system]
39 STOP SLAVE;
40 Warnings:
41 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
42 REVOKE SYSTEM_VARIABLES_ADMIN ON *.* FROM 'u1'@'localhost';
43 #
44 # TC2. Verify that replication only succeeds with
45 # `SUPER` due to the set of `pseudo_thread_id`
46 # -------------------------------------------------
47 #
48 [connection master]
49 CREATE TABLE t_super (c1 INT);
50 INSERT INTO t_super VALUES (1), (2);
51 [connection slave]
52 SHOW GRANTS FOR 'u1'@'localhost';
53 Grants for u1@localhost
54 GRANT INSERT, CREATE, DROP ON *.* TO `u1`@`localhost`
55 GRANT REPLICATION_APPLIER ON *.* TO `u1`@`localhost`
56 START SLAVE;
57 Warnings:
58 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
59 include/wait_for_slave_sql_error.inc [errno=1227]
60 STOP SLAVE;
61 Warnings:
62 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
63 GRANT SUPER ON *.* TO 'u1'@'localhost';
64 Warnings:
65 Warning 1287 The SUPER privilege identifier is deprecated
66 SHOW GRANTS FOR 'u1'@'localhost';
67 Grants for u1@localhost
68 GRANT INSERT, CREATE, DROP, SUPER ON *.* TO `u1`@`localhost`
69 GRANT REPLICATION_APPLIER ON *.* TO `u1`@`localhost`
70 START SLAVE;
71 Warnings:
72 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
73 [connection master]
74 include/sync_slave_sql_with_master.inc
75 include/diff_tables.inc [master:t_super, slave:t_super]
76 STOP SLAVE;
77 Warnings:
78 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
79 REVOKE SUPER ON *.* FROM 'u1'@'localhost';
80 Warnings:
81 Warning 1287 The SUPER privilege identifier is deprecated
82 #
83 # TC3. Verify that replication only succeeds with
84 # `SESSION_VARIABLES_ADMIN` due to the set of `pseudo_thread_id`
85 # -------------------------------------------------------------------
86 #
87 [connection master]
88 CREATE TABLE t_session (c1 INT);
89 INSERT INTO t_session VALUES (1), (2);
90 [connection slave]
91 SHOW GRANTS FOR 'u1'@'localhost';
92 Grants for u1@localhost
93 GRANT INSERT, CREATE, DROP ON *.* TO `u1`@`localhost`
94 GRANT REPLICATION_APPLIER ON *.* TO `u1`@`localhost`
95 START SLAVE;
96 Warnings:
97 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
98 include/wait_for_slave_sql_error.inc [errno=1227]
99 STOP SLAVE;
100 Warnings:
101 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
102 GRANT SESSION_VARIABLES_ADMIN ON *.* TO 'u1'@'localhost';
103 SHOW GRANTS FOR 'u1'@'localhost';
104 Grants for u1@localhost
105 GRANT INSERT, CREATE, DROP ON *.* TO `u1`@`localhost`
106 GRANT REPLICATION_APPLIER,SESSION_VARIABLES_ADMIN ON *.* TO `u1`@`localhost`
107 START SLAVE;
108 Warnings:
109 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
110 [connection master]
111 include/sync_slave_sql_with_master.inc
112 include/diff_tables.inc [master:t_session, slave:t_session]
113 STOP SLAVE;
114 Warnings:
115 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
116 #
117 # TC4. Verify that setting `default_table_encryption` only succeeds on
118 # the slave when having `SUPER` or `SYSTEM_VARIABLES_ADMIN` and
119 # `TABLE_ENCRYPTION_ADMIN`
120 # --------------------------------------------------------------------
121 #
122 [connection master]
123 SET default_table_encryption = 1;
124 CREATE DATABASE new_db;
125 [connection slave]
126 REVOKE SUPER, SYSTEM_VARIABLES_ADMIN, TABLE_ENCRYPTION_ADMIN ON *.* FROM 'u1'@'localhost';
127 Warnings:
128 Warning 1287 The SUPER privilege identifier is deprecated
129 START SLAVE;
130 Warnings:
131 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
132 include/wait_for_slave_sql_error.inc [errno=1227]
133 STOP SLAVE;
134 Warnings:
135 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
136 GRANT SYSTEM_VARIABLES_ADMIN, TABLE_ENCRYPTION_ADMIN ON *.* TO 'u1'@'localhost';
137 SHOW GRANTS FOR 'u1'@'localhost';
138 Grants for u1@localhost
139 GRANT INSERT, CREATE, DROP ON *.* TO `u1`@`localhost`
140 GRANT REPLICATION_APPLIER,SESSION_VARIABLES_ADMIN,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN ON *.* TO `u1`@`localhost`
141 START SLAVE;
142 Warnings:
143 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
144 [connection master]
145 include/sync_slave_sql_with_master.inc
146 include/assert.inc [Database new_db exists on slave]
147 [connection master]
148 DROP TABLE t_system;
149 DROP TABLE t_super;
150 DROP TABLE t_session;
151 DROP DATABASE new_db;
152 SET default_table_encryption = OPT_DEFAULT_TABLE_ENCRYPTION;
153 include/rpl_end.inc