1include/master-slave.inc 2[connection master] 3==== Create new replication user ==== 4connection master; 5GRANT REPLICATION SLAVE ON *.* TO rpl@127.0.0.1 IDENTIFIED BY 'rpl'; 6connection slave; 7include/stop_slave.inc 8set @save_relay_log_purge=@@global.relay_log_purge; 9set @@global.relay_log_purge=0; 10CHANGE MASTER TO master_user='rpl', master_password='rpl'; 11select @@global.relay_log_purge; 12@@global.relay_log_purge 130 14set @@global.relay_log_purge=1; 15CHANGE MASTER TO master_user='rpl', master_password='rpl'; 16select @@global.relay_log_purge; 17@@global.relay_log_purge 181 19set @@global.relay_log_purge=@save_relay_log_purge; 20CHANGE MASTER TO master_user='rpl', master_password='rpl'; 21include/start_slave.inc 22==== Do replication as new user ==== 23connection master; 24CREATE TABLE t1 (n INT); 25INSERT INTO t1 VALUES (1); 26connection slave; 27SELECT * FROM t1; 28n 291 30==== Delete new replication user ==== 31connection master; 32DROP USER rpl@127.0.0.1; 33FLUSH PRIVILEGES; 34connection slave; 35==== Restart slave without privileges ===== 36include/stop_slave.inc 37START SLAVE; 38include/wait_for_slave_sql_to_start.inc 39include/wait_for_slave_io_to_stop.inc 40==== Verify that Slave IO thread stopped with error ==== 41include/wait_for_slave_io_error.inc [errno=1045] 42==== Cleanup (Note that slave IO thread is not running) ==== 43include/stop_slave_sql.inc 44CHANGE MASTER TO MASTER_USER = 'root', MASTER_PASSWORD = ''; 45include/rpl_reset.inc 46connection master; 47DROP TABLE t1; 48include/rpl_end.inc 49