首页 / 数据库 / MySQL / MySQL主从配置时从 start slave 无法启动

重置 slave 配置就行了。

启动从时报错：

mysql> start slave;

ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository

reset slave之后可以：

mysql> reset slave;

Query OK, 0 rows affected (0.00 sec)

mysql> change master to master_host='172.16.1.1', master_user='re1', master_password='re1' ,master_log_file='1.000016', master_log_pos=430;

Query OK, 0 rows affected, 2 warnings (0.04 sec)

mysql> start slave;

Query OK, 0 rows affected (0.02 sec)