首页 » Linux » mysql主从同步错误

mysql主从同步错误

 

主从同步,在从库中:start slave时提示以下错误:
RROR 1201 (HY000): Could not initialize master info structure; more error messages can be
found in the MySQL error log

解决方法:reset slave
再change master to(去主库查看位置和binlog:show master status;)
change master to
-> master_host=’192.168.8.6′,
-> master_port=3306,
-> master_user=’rep’,
-> master_password=’oldboy123′,
-> master_log_file=’mysql-bin.000068′,
-> master_log_pos=190;
再start slave;
再查看是否正常:show slave status\G;

原文链接:mysql主从同步错误,转载请注明来源!

0