- 在从数据库上删除master.info,relay-log.info
- 重启从数据库/etc/init.d/mysqld restart
mysql> slave stop;
mysql> change master to master_host='192.168.1.11', master_user='zh', master_password='xxxxxx', master_log_file='mysql-bin.000003', master_log_pos=106;
mysql> slave start;
mysql> show slave status\G