Debian Codegraph @

mysql-test/suite/rpl/r/rpl_user.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 set session sql_log_bin=0;
5 delete from mysql.user where Host='fakehost';
6 set session sql_log_bin=1;
7 connection slave;
8 set session sql_log_bin=0;
9 delete from mysql.user where Host='fakehost';
10 set session sql_log_bin=1;
11 connection master;
12 create user 'foo'@'fakehost';
13 create user 'foo'@'fakehost', 'bar'@'fakehost';
14 ERROR HY000: Operation CREATE USER failed for 'foo'@'fakehost'
15 create user 'foo'@'fakehost', 'bar'@'fakehost';
16 ERROR HY000: Operation CREATE USER failed for 'foo'@'fakehost','bar'@'fakehost'
17 connection slave;
18 select Host,User from mysql.user where Host='fakehost';
19 Host User
20 fakehost bar
21 fakehost foo
22 connection master;
23 rename user 'foo'@'fakehost' to 'foofoo'@'fakehost';
24 rename user 'not_exist_user1'@'fakehost' to 'foobar'@'fakehost', 'bar'@'fakehost' to 'barbar'@'fakehost';
25 ERROR HY000: Operation RENAME USER failed for 'not_exist_user1'@'fakehost'
26 rename user 'not_exist_user1'@'fakehost' to 'foobar'@'fakehost', 'not_exist_user2'@'fakehost' to 'barfoo'@'fakehost';
27 ERROR HY000: Operation RENAME USER failed for 'not_exist_user1'@'fakehost','not_exist_user2'@'fakehost'
28 connection slave;
29 select Host,User from mysql.user where Host='fakehost';
30 Host User
31 fakehost barbar
32 fakehost foofoo
33 connection master;
34 alter user 'foofoo'@'fakehost' identified by 'foo';
35 alter user 'non_exist_user1'@'fakehost' identified by 'foo', 'barbar'@'fakehost' identified by 'bar';
36 ERROR HY000: Operation ALTER USER failed for 'non_exist_user1'@'fakehost'
37 alter user 'non_exist_user1'@'fakehost' identified by 'foo', 'non_exist_user2'@'fakehost' identified by 'bar';
38 ERROR HY000: Operation ALTER USER failed for 'non_exist_user1'@'fakehost','non_exist_user2'@'fakehost'
39 connection slave;
40 connection master;
41 drop user 'foofoo'@'fakehost';
42 drop user 'not_exist_user1'@'fakehost', 'barbar'@'fakehost';
43 ERROR HY000: Operation DROP USER failed for 'not_exist_user1'@'fakehost'
44 drop user 'not_exist_user1'@'fakehost', 'not_exist_user2'@'fakehost';
45 ERROR HY000: Operation DROP USER failed for 'not_exist_user1'@'fakehost','not_exist_user2'@'fakehost'
46 connection slave;
47 select Host,User from mysql.user where Host='fakehost';
48 Host User
49 connection master;
50 include/show_binlog_events.inc
51 Log_name Pos Event_type Server_id End_log_pos Info
52 master-bin.000001 # Gtid # # GTID #-#-#
53 master-bin.000001 # Query # # use `test`; create user 'foo'@'fakehost'
54 master-bin.000001 # Gtid # # GTID #-#-#
55 master-bin.000001 # Query # # use `test`; create user 'foo'@'fakehost', 'bar'@'fakehost'
56 master-bin.000001 # Gtid # # GTID #-#-#
57 master-bin.000001 # Query # # use `test`; rename user 'foo'@'fakehost' to 'foofoo'@'fakehost'
58 master-bin.000001 # Gtid # # GTID #-#-#
59 master-bin.000001 # Query # # use `test`; rename user 'not_exist_user1'@'fakehost' to 'foobar'@'fakehost', 'bar'@'fakehost' to 'barbar'@'fakehost'
60 master-bin.000001 # Gtid # # GTID #-#-#
61 master-bin.000001 # Query # # use `test`; alter user 'foofoo'@'fakehost' identified by 'foo'
62 master-bin.000001 # Gtid # # GTID #-#-#
63 master-bin.000001 # Query # # use `test`; alter user 'non_exist_user1'@'fakehost' identified by 'foo', 'barbar'@'fakehost' identified by 'bar'
64 master-bin.000001 # Gtid # # GTID #-#-#
65 master-bin.000001 # Query # # use `test`; drop user 'foofoo'@'fakehost'
66 master-bin.000001 # Gtid # # GTID #-#-#
67 master-bin.000001 # Query # # use `test`; drop user 'not_exist_user1'@'fakehost', 'barbar'@'fakehost'
68 include/rpl_end.inc