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