MySql数据库主从配置失败以后的处理方式

1. 在从节点执行以下步骤

         (1) stop slave;
         (2) change master to master_auto_position=0;
         (3) CHANGE MASTER TO
             MASTER_HOST='192.168.105.8',
             MASTER_USER='guomaiuser',
             MASTER_PASSWORD='jhq910129',
             MASTER_LOG_FILE='mysql-bin.000053',
             MASTER_LOG_POS=234;
         (4) start slave;
         (5) show slave status\G