\MySQL Server 5.5 主从同步报错unknown variable 'master-host=192.168.8.111'
\MySQL Server 5.5 主从同步报错unknown variable 'master-host=192.168.8.111'
错误如下:
120401 15:45:44 [ERROR] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: unknown variable 'master-host=192.168.8.111'
120401 15:45:44 [ERROR] Aborting
my配置如下:
[mysqld]
log-error=C:/Program Files/MySQL/MySQL Server 5.5/logerror.log
log=C:/Program Files/MySQL/MySQL Server 5.5/log.log
server-id=2
master-host=192.168.8.111
master-user=backup
master-password=backup
master-port=3306
master-connect-retry=60
请问那位老大知道原因
------解决方案--------------------
Mysql版本从5.1.7以后开始就不支持“master-host”类似的参数
在从库上执行如下命令;
change master to master_host='masterIP', master_user='slave', master_password='slvaePASS';
slave start;
切记:
此处是masterIP地址,不是slave地址,而登陆账号为slave账号密码
------解决方案--------------------
master-host=192.168.8.111
master-user=backup
master-password=backup
master-port=3306
master-connect-retry=60
这些参数 mysql5.5已经废弃了
必须在slave上用change master to 来设置slave