ERROR 1201 (HY000): Could not initialize master!解决方法
来源:互联网 发布:河南网络诈骗案例 编辑:程序博客网 时间:2024/05/17 20:23
from:http://waynerqiu.com/3/74.html
mysql互为主从,但是在SLAVE执行CHANGE MASTER时,出现这个错误: ERROR 1201 (HY000): Could not initialize master! 错误如下:
mysql>
mysql> slave stop;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> change master to master_host='192.168.100.10',master_user='replication',master_password='123456',master_log_file='updatelog.000004',master_log_pos=106;
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
网上查了一些资料,终于找到一个很好的解决办法(如下):
mysql> slave stop;
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.100.10',master_user='replication',master_password='123456',master_log_file='updatelog.000004',master_log_pos=106;
Query OK, 0 rows affected (0.05 sec)
mysql> slave start;
Query OK, 0 rows affected (0.00 sec)
这样就完成mysql主从设置了,你可以执行
mysql > show slave status \G;
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
出现这个问题的原因,应该是以前mysql做过主从! 3G、路
- ERROR 1201 (HY000): Could not initialize master!解决方法
- ERROR 1201 (HY000): Could not initialize master info structure解决方法
- ERROR 1201 (HY000): Could not initialize master info structure
- 解决ERROR 1201 (HY000): Could not initialize master info structure
- ERROR 1201 (HY000):Could not initialize master info structure,ERROR 29 (HY000): File'./web_appdb_的问题
- ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in
- ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in
- MySQL Slave环境出现ERROR 1201 (HY000): Could not initialize master info structure的案例
- ERROR 1201 (HY000):Could not initialize master info structure的问题(转载)
- MySQL主从复制:ERROR 1201 (HY000): Could not initialize master info structure.
- mysql Could not initialize master info structure 解决方法
- mysql Could not initialize master info structure;
- Could not initialize master info structure; more error messages can be found in the MySQL error log
- ERROR - could not initialize proxy - no Session
- ERROR: Could not initialize SDL video.问题解决
- mysql Could not initialize master info structure; more error messages can be found in the MySQL erro
- 故障案例:级联主从change master to Could not initialize master info structure
- error:Could not initialize class net.sf.cglib.proxy.Enhancer
- 宣布正式发布 Biz Talk Services、Azure Active Directory 和 Traffic Manager, 同时发布 Azure Active Directory 高级版预览
- 2618 手机键盘
- 叠筐 2074
- tar命令批量解压方法总结
- jsp:useBean用法
- ERROR 1201 (HY000): Could not initialize master!解决方法
- eclipse+maven搭建web项目
- 汉诺塔
- 测试
- DQL汇总(2)
- PullToRefreshListView 进入不能进入刷新状态解决
- 2715 Theatre Square
- 获取default gateway的shell脚本
- NFC协议学习分享-1