ERROR 1201 (HY000): Could not initialize master info structure; more error messa

最新推荐文章于 2021-05-07 19:30:50 发布

stevenfeng

最新推荐文章于 2021-05-07 19:30:50 发布

阅读量175

点赞数

分类专栏： mysql 文章标签：数据库

本文链接：https://blog.csdn.net/fengqinyun168/article/details/84416273

版权

mysql 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

mysql主从复制时从库执行
change master to master_host='192.168.0.91',master_user='backup',master_password='backup',master_log_file='mysql-bin.000001',master_log_pos=98
发生错误如下；
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.0.91',master_user='backup',master_password='backup',master_log_file='mysql-bin.000001',master_log_pos=98;
Query OK, 0 rows affected (0.01 sec)