stop slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; reset master; reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; Master_User root Master_Host 127.0.0.1 include/stop_slave.inc change master to master_user='test'; Master_User test Master_Host 127.0.0.1 reset slave; Master_User test Master_Host 127.0.0.1 change master to master_user='root'; include/start_slave.inc Master_User root Master_Host 127.0.0.1 include/stop_slave.inc reset slave; include/start_slave.inc create temporary table t1 (a int); include/stop_slave.inc reset slave; include/start_slave.inc show status like 'slave_open_temp_tables'; Variable_name Value Slave_open_temp_tables 1 include/stop_slave.inc reset slave; change master to master_user='impossible_user_name'; start slave; stop slave; change master to master_user='root'; include/start_slave.inc stop slave; change master to master_user='impossible_user_name'; start slave; stop slave; reset slave;