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