rpl_grant.result 1.2 KB
Newer Older
1 2 3 4 5 6 7 8 9
stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
**** On Master ****
CREATE USER dummy@localhost;
CREATE USER dummy1@localhost, dummy2@localhost;
unknown's avatar
unknown committed
10
SELECT user, host FROM mysql.user WHERE user like 'dummy%';
11 12 13 14
user	host
dummy	localhost
dummy1	localhost
dummy2	localhost
unknown's avatar
unknown committed
15
SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%';
unknown's avatar
unknown committed
16
COUNT(*)
unknown's avatar
unknown committed
17
3
18
**** On Slave ****
unknown's avatar
unknown committed
19
SELECT user,host FROM mysql.user WHERE user like 'dummy%';
20 21 22 23
user	host
dummy	localhost
dummy1	localhost
dummy2	localhost
unknown's avatar
unknown committed
24
SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%';
unknown's avatar
unknown committed
25
COUNT(*)
unknown's avatar
unknown committed
26
3
27 28 29 30 31 32
**** On Master ****
DROP USER nonexisting@localhost;
ERROR HY000: Operation DROP USER failed for 'nonexisting'@'localhost'
DROP USER nonexisting@localhost, dummy@localhost;
ERROR HY000: Operation DROP USER failed for 'nonexisting'@'localhost'
DROP USER dummy1@localhost, dummy2@localhost;
unknown's avatar
unknown committed
33
SELECT user, host FROM mysql.user WHERE user like 'dummy%';
34
user	host
unknown's avatar
unknown committed
35
SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%';
unknown's avatar
unknown committed
36
COUNT(*)
unknown's avatar
unknown committed
37
0
38
**** On Slave ****
unknown's avatar
unknown committed
39
SELECT user,host FROM mysql.user WHERE user like 'dummy%';
40
user	host
unknown's avatar
unknown committed
41
SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%';
unknown's avatar
unknown committed
42
COUNT(*)
unknown's avatar
unknown committed
43
0