mysql主从死机后重新配置主从
<p>主机重新配置主从
mysql> reset master;
<img src="https://www.showdoc.cc/server/api/common/visitfile/sign/720353d1e1ba91506cce137296b52dfe?showdoc=.jpg" alt="" />
mysql>show master status \G;
<img src="https://www.showdoc.cc/server/api/common/visitfile/sign/9d9e2bb8405e8c4c3e60819474398424?showdoc=.jpg" alt="" /></p>
<p>从机重新配置主从
mysql> stop slave;
<img src="https://www.showdoc.cc/server/api/common/visitfile/sign/f024d4968bc544e67b88bdb62fb3f5f6?showdoc=.jpg" alt="" />
mysql> change master to master_host='192.168.1.44',master_user='mark',master_password='123456',master_log_file='mysql-bin-5.000001',master_log_pos=154;
<img src="https://www.showdoc.cc/server/api/common/visitfile/sign/77354c8791a8ef2592d80cb28a57314c?showdoc=.jpg" alt="" />
mysql> start slave;
<img src="https://www.showdoc.cc/server/api/common/visitfile/sign/c10aa89d9e43cbd9f7699601bbe9aa96?showdoc=.jpg" alt="" />
mysql> show slave status \G;
<img src="https://www.showdoc.cc/server/api/common/visitfile/sign/5f280c0b561f6877a7fc79180361e826?showdoc=.jpg" alt="" /></p>