Home >Database >Mysql Tutorial >Mysql-5.5.3主从同步不支持master-host问题的解决办法_MySQL

Mysql-5.5.3主从同步不支持master-host问题的解决办法_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:29:011359browse

bitsCN.com

Mysql-5.5.3主从同步不支持master-host问题的解决办法

 

修改my.cnf后的master-host不行,查了下终于得知原因:

 

Mysql版本从5.1.7以后开始就不支持“master-host”类似的参数

 

替代方法:

 

change master to master_host='masterIP', master_user='slave', master_password='slvaePASS';slave start;

 

 

切记:

 

此处是masterIP地址,不是slave地址,而登陆账号为slave账号密码,

 

大家别在这绕弯,哥磨了三天,最后才知道错误原因。

 

bitsCN.com
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn