ERROR 1201 (HY000): Could not initialize master info structure; .....
配置mysql主从复制，start slave是报错：ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
原因：之前做过主从复制
解决办法：
mysql> stop slave;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> reset slave;
Query OK, 0 rows affected (0.00 sec)
mysql> CHANGE MASTER TO
-> MASTER_HOST='192.168.122.10',
-> MASTER_PORT=3306,
-> MASTER_USER='repl',
-> MASTER_PASSWORD='repl',
-> MASTER_LOG_FILE='mysql-bin.000015',
-> MASTER_LOG_POS=192;
Query OK, 0 rows affected (0.14 sec)
mysql> start slave;
Query OK, 0 rows affected (0.07 sec)
原因：之前做过主从复制
解决办法：
mysql> stop slave;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> reset slave;
Query OK, 0 rows affected (0.00 sec)
mysql> CHANGE MASTER TO
-> MASTER_HOST='192.168.122.10',
-> MASTER_PORT=3306,
-> MASTER_USER='repl',
-> MASTER_PASSWORD='repl',
-> MASTER_LOG_FILE='mysql-bin.000015',
-> MASTER_LOG_POS=192;
Query OK, 0 rows affected (0.14 sec)
mysql> start slave;
Query OK, 0 rows affected (0.07 sec)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30373263/viewspace-2121795/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
RMAN跨平台传输数据库和表空间
下一篇：
mysql主从复制丛库IO进程问题
请登录后发表评论
登录
全部评论
