1include/master-slave.inc
2[connection master]
3connection slave;
4include/stop_slave.inc
5connection master;
6create user 'repl_user' password expire;
7grant replication slave on *.* to repl_user;
8flush privileges;
9set global disconnect_on_expired_password=ON;
10connection slave;
11CHANGE MASTER TO MASTER_USER= 'repl_user';
12START SLAVE;
13include/wait_for_slave_io_error.inc [errno=1862]
14include/stop_slave_sql.inc
15RESET SLAVE;
16connection master;
17set global disconnect_on_expired_password=OFF;
18connection slave;
19START SLAVE;
20include/wait_for_slave_io_error.inc [errno=1820]
21connection master;
22DROP USER 'repl_user';
23set global disconnect_on_expired_password=default;
24connection slave;
25include/stop_slave_sql.inc
26CHANGE MASTER TO MASTER_USER='root';
27RESET SLAVE;
28include/rpl_end.inc
29