`

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

 
阅读更多
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)
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics