mysql - 错误 : "could not initailize master info structure" while doing Master Slave Replication in MySQL

Question

我正在尝试为 MySQL 做主从复制。当我输入以下命令时:

CHANGE MASTER TO MASTER_HOST='10.1.100.1', MASTER_USER='slave_user', MASTER_PASSWORD='slave_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=451228;
mysql> START SLAVE;

它会抛出以下错误:

ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log

任何帮助将不胜感激。

Answer 1

尝试重置它，它确实很神奇! ON SLAVE THE SLAVE MYSQL 命令类型:

RESET SLAVE;

然后再试一次:

CHANGE MASTER TO MASTER_HOST='10.1.100.1', MASTER_USER='slave_user', MASTER_PASSWORD='slave_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=451228;
mysql> START SLAVE;