mysql 5.5 5.6 主从_mysql5.6+版本主从设置(mysql5.5之后的主从设置跟5.5之前的差别)

今天做mysql主从复制test的时候遇到的问题, 我的mysql version 是5.6.29:

在slave server 上配置my.cnf, 添加

master-host=192.168.124.51

master-user= AffairLog

master-password= password

master-port=3306

重启mysqld服务后,报一下错误

# /etc/init.d/mysqld restart

ERROR! MySQL server PID file could not be found!

Starting MySQL.. ERROR! The server quit without updating PID file (/var/mysql/data/csw.pid).

在mysql官方文档search replication slave options

找到

http://dev.mysql.com/doc/refman/5.6/en/replication-options-slave.html

最后发现在这篇文档里有说

Obsolete Replication Slave Options

The following options are removed in MySQL 5.5. If you attempt to start mysqld with any of these options in MySQL 5.6, the server aborts with an unknown variable error. To set the replication parameters formerly associated with these options, you must use the CHANGE MASTER TO ... statemen