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;
7
delete from mysql.user where user=_binary'rpl_do_grant';
8
delete from mysql.db where user=_binary'rpl_do_grant';
10
delete from mysql.user where user=_binary'rpl_ignore_grant';
11
delete from mysql.db where user=_binary'rpl_ignore_grant';
13
grant select on *.* to rpl_do_grant@localhost;
14
grant drop on test.* to rpl_do_grant@localhost;
15
show grants for rpl_do_grant@localhost;
16
Grants for rpl_do_grant@localhost
17
GRANT SELECT ON *.* TO 'rpl_do_grant'@'localhost'
18
GRANT DROP ON `test`.* TO 'rpl_do_grant'@'localhost'
19
set password for rpl_do_grant@localhost=password("does it work?");
20
select password<>_binary'' from mysql.user where user=_binary'rpl_do_grant';
23
delete from mysql.user where user=_binary'rpl_do_grant';
24
delete from mysql.db where user=_binary'rpl_do_grant';
26
delete from mysql.user where user=_binary'rpl_do_grant';
27
delete from mysql.db where user=_binary'rpl_do_grant';
29
show grants for rpl_do_grant@localhost;
30
ERROR 42000: There is no such grant defined for user 'rpl_do_grant' on host 'localhost'
31
show grants for rpl_do_grant@localhost;
32
ERROR 42000: There is no such grant defined for user 'rpl_do_grant' on host 'localhost'
33
create user rpl_do_grant@localhost;
34
show grants for rpl_do_grant@localhost;
35
Grants for rpl_do_grant@localhost
36
GRANT USAGE ON *.* TO 'rpl_do_grant'@'localhost'
37
show grants for rpl_do_grant2@localhost;
38
ERROR 42000: There is no such grant defined for user 'rpl_do_grant2' on host 'localhost'
39
show grants for rpl_do_grant@localhost;
40
Grants for rpl_do_grant@localhost
41
GRANT USAGE ON *.* TO 'rpl_do_grant'@'localhost'
42
show grants for rpl_do_grant2@localhost;
43
ERROR 42000: There is no such grant defined for user 'rpl_do_grant2' on host 'localhost'
44
rename user rpl_do_grant@localhost to rpl_do_grant2@localhost;
45
show grants for rpl_do_grant2@localhost;
46
Grants for rpl_do_grant2@localhost
47
GRANT USAGE ON *.* TO 'rpl_do_grant2'@'localhost'
48
show grants for rpl_do_grant2@localhost;
49
Grants for rpl_do_grant2@localhost
50
GRANT USAGE ON *.* TO 'rpl_do_grant2'@'localhost'
51
grant DELETE,INSERT on mysqltest1.* to rpl_do_grant2@localhost;
52
show grants for rpl_do_grant2@localhost;
53
Grants for rpl_do_grant2@localhost
54
GRANT USAGE ON *.* TO 'rpl_do_grant2'@'localhost'
55
GRANT INSERT, DELETE ON `mysqltest1`.* TO 'rpl_do_grant2'@'localhost'
56
show grants for rpl_do_grant2@localhost;
57
Grants for rpl_do_grant2@localhost
58
GRANT USAGE ON *.* TO 'rpl_do_grant2'@'localhost'
59
GRANT INSERT, DELETE ON `mysqltest1`.* TO 'rpl_do_grant2'@'localhost'
60
revoke DELETE on mysqltest1.* from rpl_do_grant2@localhost;
61
show grants for rpl_do_grant2@localhost;
62
Grants for rpl_do_grant2@localhost
63
GRANT USAGE ON *.* TO 'rpl_do_grant2'@'localhost'
64
GRANT INSERT ON `mysqltest1`.* TO 'rpl_do_grant2'@'localhost'
65
show grants for rpl_do_grant2@localhost;
66
Grants for rpl_do_grant2@localhost
67
GRANT USAGE ON *.* TO 'rpl_do_grant2'@'localhost'
68
GRANT INSERT ON `mysqltest1`.* TO 'rpl_do_grant2'@'localhost'
69
revoke all privileges, grant option from rpl_do_grant2@localhost;
70
show grants for rpl_do_grant2@localhost;
71
Grants for rpl_do_grant2@localhost
72
GRANT USAGE ON *.* TO 'rpl_do_grant2'@'localhost'
73
show grants for rpl_do_grant2@localhost;
74
Grants for rpl_do_grant2@localhost
75
GRANT USAGE ON *.* TO 'rpl_do_grant2'@'localhost'
76
drop user rpl_do_grant2@localhost;
77
show grants for rpl_do_grant2@localhost;
78
ERROR 42000: There is no such grant defined for user 'rpl_do_grant2' on host 'localhost'
79
show grants for rpl_do_grant2@localhost;
80
ERROR 42000: There is no such grant defined for user 'rpl_do_grant2' on host 'localhost'