2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
1
include/master-slave.inc
7
3
delete from mysql.user where user=_binary'rpl_do_grant';
8
4
delete from mysql.db where user=_binary'rpl_do_grant';
166
162
DROP FUNCTION upgrade_del_func;
167
163
DROP FUNCTION upgrade_alter_func;
168
164
DROP DATABASE bug42217_db;
169
166
DROP USER 'create_rout_db'@'localhost';
171
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
174
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
168
include/rpl_reset.inc
176
170
######## BUG#49119 #######
177
171
### i) test case from the 'how to repeat section'
179
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
182
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
184
172
CREATE TABLE t1(c1 INT);
185
173
CREATE PROCEDURE p1() SELECT * FROM t1 |
186
174
REVOKE EXECUTE ON PROCEDURE p1 FROM 'root'@'localhost';
189
177
DROP PROCEDURE p1;
190
178
### ii) Test case in which REVOKE partially succeeds
192
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
195
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
179
include/rpl_reset.inc
197
180
CREATE TABLE t1(c1 INT);
198
181
CREATE PROCEDURE p1() SELECT * FROM t1 |
199
182
CREATE USER 'user49119'@'localhost';
247
230
DROP PROCEDURE p1;
248
231
DROP USER 'user49119'@'localhost';
250
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
253
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
232
include/rpl_reset.inc
255
233
grant all on *.* to foo@"1.2.3.4";
256
234
revoke all privileges, grant option from "foo";
257
235
ERROR HY000: Can't revoke all privileges for one or more of the requested users
259
237
Log_name Pos Event_type Server_id End_log_pos Info
260
238
master-bin.000001 # Query # # use `test`; grant all on *.* to foo@"1.2.3.4"
261
239
master-bin.000001 # Query # # use `test`; revoke all privileges, grant option from "foo"
240
include/check_slave_no_error.inc
262
241
DROP USER foo@"1.2.3.4";
264
243
# Bug#27606 GRANT statement should be replicated with DEFINER information
266
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
269
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
244
include/rpl_reset.inc
271
245
GRANT SELECT, INSERT ON mysql.user TO user_bug27606@localhost;
272
246
SELECT Grantor FROM mysql.tables_priv WHERE User='user_bug27606';