← Back to branch summary

~vlad-lesin/percona-server/mysql-5.0.33-original

« back to all changes in this revision

Viewing changes to mysql-test/r/rpl_ignore_grant.result

  • Committer: Vlad Lesin
  • Date: 2012-07-31 09:21:34 UTC
  • Revision ID: vladislav.lesin@percona.com-20120731092134-zfodx022b7992wsi
Virgin 5.0.33

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/rpl_ignore_grant.result
 
1
stop slave;
 
2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
3
reset master;
 
4
reset slave;
 
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
6
start slave;
 
7
delete from mysql.user where user=_binary'rpl_ignore_grant';
 
8
delete from mysql.db where user=_binary'rpl_ignore_grant';
 
9
flush privileges;
 
10
delete from mysql.user where user=_binary'rpl_ignore_grant';
 
11
delete from mysql.db where user=_binary'rpl_ignore_grant';
 
12
flush privileges;
 
13
grant select on *.* to rpl_ignore_grant@localhost;
 
14
grant drop on test.* to rpl_ignore_grant@localhost;
 
15
show grants for rpl_ignore_grant@localhost;
 
16
Grants for rpl_ignore_grant@localhost
 
17
GRANT SELECT ON *.* TO 'rpl_ignore_grant'@'localhost'
 
18
GRANT DROP ON `test`.* TO 'rpl_ignore_grant'@'localhost'
 
19
show grants for rpl_ignore_grant@localhost;
 
20
ERROR 42000: There is no such grant defined for user 'rpl_ignore_grant' on host 'localhost'
 
21
select count(*) from mysql.user where user=_binary'rpl_ignore_grant';
 
22
count(*)
 
23
0
 
24
select count(*) from mysql.db where user=_binary'rpl_ignore_grant';
 
25
count(*)
 
26
0
 
27
grant select on *.* to rpl_ignore_grant@localhost;
 
28
set password for rpl_ignore_grant@localhost=password("does it work?");
 
29
select password<>_binary'' from mysql.user where user=_binary'rpl_ignore_grant';
 
30
password<>_binary''
 
31
0
 
32
delete from mysql.user where user=_binary'rpl_ignore_grant';
 
33
delete from mysql.db where user=_binary'rpl_ignore_grant';
 
34
flush privileges;
 
35
delete from mysql.user where user=_binary'rpl_ignore_grant';
 
36
delete from mysql.db where user=_binary'rpl_ignore_grant';
 
37
flush privileges;