mysql主从：从库重置slave服务

mysql主从：从库重置slave服务

stop slave;

reset slave;

change master to master_auto_position=0;

change master to master_host='192.168.12.13',master_port=3306,master_user='test1',
master_password='test123',master_log_file='binlog.000143',master_log_pos=232;

start slave;