1include/master-slave.inc 2[connection master] 3connection slave; 4Master_User = 'root' 5Master_Host = '127.0.0.1' 6include/stop_slave.inc 7change master to master_user='test'; 8Master_User = 'test' 9Master_Host = '127.0.0.1' 10reset slave; 11Master_User = 'test' 12Master_Host = '127.0.0.1' 13change master to master_user='root'; 14include/start_slave.inc 15Master_User = 'root' 16Master_Host = '127.0.0.1' 17include/stop_slave.inc 18reset slave; 19include/start_slave.inc 20connection master; 21create temporary table t1 (a int); 22connection slave; 23include/stop_slave.inc 24reset slave; 25include/start_slave.inc 26show status like 'slave_open_temp_tables'; 27Variable_name Value 28Slave_open_temp_tables 1 29connection master; 30drop temporary table if exists t1; 31connection slave; 32include/stop_slave.inc 33reset slave; 34include/check_slave_no_error.inc 35change master to master_user='impossible_user_name'; 36start slave; 37include/wait_for_slave_io_error.inc [errno=1045] 38include/stop_slave_sql.inc 39change master to master_user='root'; 40include/start_slave.inc 41include/check_slave_no_error.inc 42stop slave; 43change master to master_user='impossible_user_name'; 44start slave; 45include/wait_for_slave_io_error.inc [errno=1045] 46include/stop_slave_sql.inc 47reset slave; 48include/check_slave_no_error.inc 49change master to master_user='root'; 50reset slave; 51include/start_slave.inc 52include/stop_slave.inc 53reset slave all; 54start slave; 55ERROR HY000: Misconfigured slave: MASTER_HOST was not set; Fix in config file or with CHANGE MASTER TO 56CHANGE MASTER TO MASTER_HOST= 'MASTER_HOST', MASTER_USER= 'MASTER_USER', MASTER_PORT= MASTER_PORT; 57include/start_slave.inc 58include/rpl_end.inc 59