Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_do_grant.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 call mtr.add_suppression("REVOKE/GRANT failed while storing routine level "
7 "grants in the privilege tables. An incident event "
8 "has been written to the binary log which will "
9 "stop the slaves.");
10 delete from mysql.user where user=_binary'rpl_do_grant';
11 delete from mysql.db where user=_binary'rpl_do_grant';
12 flush privileges;
13 delete from mysql.user where user=_binary'rpl_ignore_grant';
14 delete from mysql.db where user=_binary'rpl_ignore_grant';
15 flush privileges;
16 create user rpl_do_grant@localhost;
17 grant select on *.* to rpl_do_grant@localhost;
18 grant drop on test.* to rpl_do_grant@localhost;
19 show grants for rpl_do_grant@localhost;
20 Grants for rpl_do_grant@localhost
21 GRANT SELECT ON *.* TO `rpl_do_grant`@`localhost`
22 GRANT DROP ON `test`.* TO `rpl_do_grant`@`localhost`
23 set password for rpl_do_grant@localhost="does it work?";
24 select authentication_string<>_binary'' from mysql.user where user=_binary'rpl_do_grant';
25 authentication_string<>_binary''
26 1
27 update mysql.user set authentication_string='' where user='rpl_do_grant';
28 flush privileges;
29 select authentication_string<>'' from mysql.user where user='rpl_do_grant';
30 authentication_string<>''
31 0
32 set sql_mode='ANSI_QUOTES';
33 set password for rpl_do_grant@localhost='does it work?';
34 set sql_mode='';
35 select authentication_string<>'' from mysql.user where user='rpl_do_grant';
36 authentication_string<>''
37 1
38 delete from mysql.user where user=_binary'rpl_do_grant';
39 delete from mysql.db where user=_binary'rpl_do_grant';
40 flush privileges;
41 delete from mysql.user where user=_binary'rpl_do_grant';
42 delete from mysql.db where user=_binary'rpl_do_grant';
43 flush privileges;
44 show grants for rpl_do_grant@localhost;
45 ERROR 42000: There is no such grant defined for user 'rpl_do_grant' on host 'localhost'
46 show grants for rpl_do_grant@localhost;
47 ERROR 42000: There is no such grant defined for user 'rpl_do_grant' on host 'localhost'
48 create user rpl_do_grant@localhost;
49 show grants for rpl_do_grant@localhost;
50 Grants for rpl_do_grant@localhost
51 GRANT USAGE ON *.* TO `rpl_do_grant`@`localhost`
52 show grants for rpl_do_grant2@localhost;
53 ERROR 42000: There is no such grant defined for user 'rpl_do_grant2' on host 'localhost'
54 show grants for rpl_do_grant@localhost;
55 Grants for rpl_do_grant@localhost
56 GRANT USAGE ON *.* TO `rpl_do_grant`@`localhost`
57 show grants for rpl_do_grant2@localhost;
58 ERROR 42000: There is no such grant defined for user 'rpl_do_grant2' on host 'localhost'
59 rename user rpl_do_grant@localhost to rpl_do_grant2@localhost;
60 show grants for rpl_do_grant2@localhost;
61 Grants for rpl_do_grant2@localhost
62 GRANT USAGE ON *.* TO `rpl_do_grant2`@`localhost`
63 show grants for rpl_do_grant2@localhost;
64 Grants for rpl_do_grant2@localhost
65 GRANT USAGE ON *.* TO `rpl_do_grant2`@`localhost`
66 grant DELETE,INSERT on mysqltest1.* to rpl_do_grant2@localhost;
67 show grants for rpl_do_grant2@localhost;
68 Grants for rpl_do_grant2@localhost
69 GRANT USAGE ON *.* TO `rpl_do_grant2`@`localhost`
70 GRANT INSERT, DELETE ON `mysqltest1`.* TO `rpl_do_grant2`@`localhost`
71 show grants for rpl_do_grant2@localhost;
72 Grants for rpl_do_grant2@localhost
73 GRANT USAGE ON *.* TO `rpl_do_grant2`@`localhost`
74 GRANT INSERT, DELETE ON `mysqltest1`.* TO `rpl_do_grant2`@`localhost`
75 revoke DELETE on mysqltest1.* from rpl_do_grant2@localhost;
76 show grants for rpl_do_grant2@localhost;
77 Grants for rpl_do_grant2@localhost
78 GRANT USAGE ON *.* TO `rpl_do_grant2`@`localhost`
79 GRANT INSERT ON `mysqltest1`.* TO `rpl_do_grant2`@`localhost`
80 show grants for rpl_do_grant2@localhost;
81 Grants for rpl_do_grant2@localhost
82 GRANT USAGE ON *.* TO `rpl_do_grant2`@`localhost`
83 GRANT INSERT ON `mysqltest1`.* TO `rpl_do_grant2`@`localhost`
84 revoke all privileges, grant option from rpl_do_grant2@localhost;
85 show grants for rpl_do_grant2@localhost;
86 Grants for rpl_do_grant2@localhost
87 GRANT USAGE ON *.* TO `rpl_do_grant2`@`localhost`
88 show grants for rpl_do_grant2@localhost;
89 Grants for rpl_do_grant2@localhost
90 GRANT USAGE ON *.* TO `rpl_do_grant2`@`localhost`
91 drop user rpl_do_grant2@localhost;
92 show grants for rpl_do_grant2@localhost;
93 ERROR 42000: There is no such grant defined for user 'rpl_do_grant2' on host 'localhost'
94 show grants for rpl_do_grant2@localhost;
95 ERROR 42000: There is no such grant defined for user 'rpl_do_grant2' on host 'localhost'
96 call mtr.add_suppression("Replica: Operation DROP USER failed for 'create_rout_db'@'localhost' Error_code: 1396");
97 DROP DATABASE IF EXISTS bug42217_db;
98 CREATE DATABASE bug42217_db;
99 CREATE USER 'create_rout_db'@'localhost' IDENTIFIED BY 'create_rout_db';
100 GRANT CREATE ROUTINE ON bug42217_db.* TO 'create_rout_db'@'localhost'
101 WITH GRANT OPTION;
102 USE bug42217_db;
103 CREATE FUNCTION upgrade_del_func() RETURNS CHAR(30)
104 BEGIN
105 RETURN "INSIDE upgrade_del_func()";
106 END//
107 USE bug42217_db;
108 SELECT * FROM mysql.procs_priv;
109 Host Db User Routine_name Routine_type Grantor Proc_priv Timestamp
110 localhost bug42217_db create_rout_db upgrade_del_func FUNCTION create_rout_db@localhost Execute,Alter Routine #
111 SELECT upgrade_del_func();
112 upgrade_del_func()
113 INSIDE upgrade_del_func()
114 FLUSH PRIVILEGES;
115 FLUSH TABLES;
116 SELECT * FROM mysql.procs_priv;
117 Host Db User Routine_name Routine_type Grantor Proc_priv Timestamp
118 localhost bug42217_db create_rout_db upgrade_del_func FUNCTION create_rout_db@localhost Execute,Alter Routine #
119 SHOW GRANTS FOR 'create_rout_db'@'localhost';
120 Grants for create_rout_db@localhost
121 GRANT USAGE ON *.* TO `create_rout_db`@`localhost`
122 GRANT CREATE ROUTINE ON `bug42217_db`.* TO `create_rout_db`@`localhost` WITH GRANT OPTION
123 GRANT EXECUTE, ALTER ROUTINE ON FUNCTION `bug42217_db`.`upgrade_del_func` TO `create_rout_db`@`localhost`
124 USE bug42217_db;
125 SHOW CREATE FUNCTION upgrade_del_func;
126 Function sql_mode Create Function character_set_client collation_connection Database Collation
127 upgrade_del_func ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`create_rout_db`@`localhost` FUNCTION `upgrade_del_func`() RETURNS char(30) CHARSET utf8mb4
128 BEGIN
129 RETURN "INSIDE upgrade_del_func()";
130 END utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
131 SELECT upgrade_del_func();
132 upgrade_del_func()
133 INSIDE upgrade_del_func()
134 "Check whether the definer user will be able to execute the replicated routine on slave"
135 USE bug42217_db;
136 SHOW CREATE FUNCTION upgrade_del_func;
137 Function sql_mode Create Function character_set_client collation_connection Database Collation
138 upgrade_del_func ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`create_rout_db`@`localhost` FUNCTION `upgrade_del_func`() RETURNS char(30) CHARSET utf8mb4
139 BEGIN
140 RETURN "INSIDE upgrade_del_func()";
141 END utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
142 SELECT upgrade_del_func();
143 upgrade_del_func()
144 INSIDE upgrade_del_func()
145 DELETE FROM mysql.procs_priv;
146 FLUSH PRIVILEGES;
147 USE bug42217_db;
148 "Can't execute the replicated routine on slave like before after procs privilege is deleted "
149 SELECT upgrade_del_func();
150 ERROR 42000: execute command denied to user 'create_rout_db'@'localhost' for routine 'bug42217_db.upgrade_del_func'
151 "Test the user who creates a function on master doesn't exist on slave."
152 "Hence SQL thread ACL_GLOBAL privilege jumps in and no mysql.procs_priv is inserted"
153 DROP USER 'create_rout_db'@'localhost';
154 Warnings:
155 Warning 4005 User 'create_rout_db'@'localhost' is referenced as a definer account in a stored routine.
156 CREATE FUNCTION upgrade_alter_func() RETURNS CHAR(30)
157 BEGIN
158 RETURN "INSIDE upgrade_alter_func()";
159 END//
160 SELECT upgrade_alter_func();
161 upgrade_alter_func()
162 INSIDE upgrade_alter_func()
163 SHOW CREATE FUNCTION upgrade_alter_func;
164 Function sql_mode Create Function character_set_client collation_connection Database Collation
165 upgrade_alter_func ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`create_rout_db`@`localhost` FUNCTION `upgrade_alter_func`() RETURNS char(30) CHARSET utf8mb4
166 BEGIN
167 RETURN "INSIDE upgrade_alter_func()";
168 END utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
169 "Should no privilege record for upgrade_alter_func in mysql.procs_priv"
170 SELECT * FROM mysql.procs_priv;
171 Host Db User Routine_name Routine_type Grantor Proc_priv Timestamp
172 SELECT upgrade_alter_func();
173 ERROR HY000: The user specified as a definer ('create_rout_db'@'localhost') does not exist
174 USE bug42217_db;
175 DROP FUNCTION upgrade_del_func;
176 DROP FUNCTION upgrade_alter_func;
177 DROP DATABASE bug42217_db;
178 SET SQL_LOG_BIN= 0;
179 DROP USER 'create_rout_db'@'localhost';
180 SET SQL_LOG_BIN= 1;
181 include/rpl_reset.inc
182 USE test;
183 ######## BUG#49119 #######
184 ### i) test case from the 'how to repeat section'
185 CREATE TABLE t1(c1 INT);
186 CREATE PROCEDURE p1() SELECT * FROM t1 |
187 REVOKE EXECUTE ON PROCEDURE p1 FROM 'root'@'localhost';
188 ERROR 42000: There is no such grant defined for user 'root' on host 'localhost' on routine 'p1'
189 DROP TABLE t1;
190 DROP PROCEDURE p1;
191 ### ii) Test case in which REVOKE partially succeeds
192 include/rpl_reset.inc
193 CREATE TABLE t1(c1 INT);
194 CREATE PROCEDURE p1() SELECT * FROM t1 |
195 CREATE USER 'user49119'@'localhost';
196 GRANT EXECUTE ON PROCEDURE p1 TO 'user49119'@'localhost';
197 ##############################################################
198 ### Showing grants for both users: root and user49119 (master)
199 SHOW GRANTS FOR 'user49119'@'localhost';
200 Grants for user49119@localhost
201 GRANT USAGE ON *.* TO `user49119`@`localhost`
202 GRANT EXECUTE ON PROCEDURE `test`.`p1` TO `user49119`@`localhost`
203 SHOW GRANTS FOR CURRENT_USER;
204 Grants for root@localhost
205 GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION
206 GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION
207 GRANT PROXY ON ``@`` TO `root`@`localhost` WITH GRANT OPTION
208 ##############################################################
209 ##############################################################
210 ### Showing grants for both users: root and user49119 (master)
211 SHOW GRANTS FOR 'user49119'@'localhost';
212 Grants for user49119@localhost
213 GRANT USAGE ON *.* TO `user49119`@`localhost`
214 GRANT EXECUTE ON PROCEDURE `test`.`p1` TO `user49119`@`localhost`
215 SHOW GRANTS FOR CURRENT_USER;
216 Grants for root@localhost
217 GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION
218 GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION
219 GRANT PROXY ON ``@`` TO `root`@`localhost` WITH GRANT OPTION
220 ##############################################################
221 ## This statement will make the revoke fail because root has no
222 ## execute grant. However, it will still revoke the grant for
223 ## user49119.
224 REVOKE EXECUTE ON PROCEDURE p1 FROM 'user49119'@'localhost', 'root'@'localhost';
225 ERROR 42000: There is no such grant defined for user 'root' on host 'localhost' on routine 'p1'
226 ##############################################################
227 ### Showing grants for both users: root and user49119 (master)
228 ### after revoke statement failure
229 SHOW GRANTS FOR 'user49119'@'localhost';
230 Grants for user49119@localhost
231 GRANT USAGE ON *.* TO `user49119`@`localhost`
232 GRANT EXECUTE ON PROCEDURE `test`.`p1` TO `user49119`@`localhost`
233 SHOW GRANTS FOR CURRENT_USER;
234 Grants for root@localhost
235 GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION
236 GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION
237 GRANT PROXY ON ``@`` TO `root`@`localhost` WITH GRANT OPTION
238 ##############################################################
239 #############################################################
240 ### Showing grants for both users: root and user49119 (slave)
241 ### after revoke statement failure (should match
242 SHOW GRANTS FOR 'user49119'@'localhost';
243 Grants for user49119@localhost
244 GRANT USAGE ON *.* TO `user49119`@`localhost`
245 GRANT EXECUTE ON PROCEDURE `test`.`p1` TO `user49119`@`localhost`
246 SHOW GRANTS FOR CURRENT_USER;
247 Grants for root@localhost
248 GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION
249 GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION
250 GRANT PROXY ON ``@`` TO `root`@`localhost` WITH GRANT OPTION
251 ##############################################################
252 DROP TABLE t1;
253 DROP PROCEDURE p1;
254 DROP USER 'user49119'@'localhost';
255 include/rpl_reset.inc
256 create user foo@"1.2.3.4";
257 grant all on *.* to foo@"1.2.3.4";
258 revoke all privileges, grant option from "foo";
259 ERROR HY000: Can't revoke all privileges for one or more of the requested users
260 include/show_binlog_events.inc
261 Log_name Pos Event_type Server_id End_log_pos Info
262 master-bin.000001 # Query # # use `test`; CREATE USER 'foo'@'1.2.3.4' IDENTIFIED WITH 'caching_sha2_password'
263 master-bin.000001 # Query # # use `test`; GRANT ALL PRIVILEGES ON *.* TO 'foo'@'1.2.3.4'
264 DROP USER foo@"1.2.3.4";
265
266 # Bug#27606 GRANT statement should be replicated with DEFINER information
267 include/rpl_reset.inc
268 CREATE USER user_bug27606@localhost;
269 GRANT SELECT, INSERT ON mysql.user TO user_bug27606@localhost;
270 SELECT Grantor FROM mysql.tables_priv WHERE User='user_bug27606';
271 Grantor
272 root@localhost
273 SELECT Grantor FROM mysql.tables_priv WHERE User='user_bug27606';
274 Grantor
275 root@localhost
276 REVOKE SELECT ON mysql.user FROM user_bug27606@localhost;
277 SELECT Grantor FROM mysql.tables_priv WHERE User='user_bug27606';
278 Grantor
279 root@localhost
280 SELECT Grantor FROM mysql.tables_priv WHERE User='user_bug27606';
281 Grantor
282 root@localhost
283 DROP USER user_bug27606@localhost;
284 include/rpl_end.inc