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