Q. No argument was provided to –log-bin, and –log-bin-index was not used; so
replication may break when this MySQL server acts as a master and has his
hostname changed!! Please use ‘–log-bin=mysql-bin’ to avoid this problem.
A: 在my.cnf 的[mysqld]中加入 log-bin=mysql-bin
Q. Neither –relay-log nor –relay-log-index were used; so replication may
break when this MySQL server acts as a slave and has his hostname changed!!
Please use ‘–relay-log=mysql-relay-bin’ to avoid this problem.
A: 在my.cnf 的[mysqld]中加入 relay-log=mysql-relay-bin
Q. [ERROR] The slave I/O thread stops because master and slave have equal
MySQL server ids; these ids must be different for replication to work (or the
–replicate-same-server-id option must be used on slave but this does not always
make sense; please check the manual before using it).
A: 在my.cnf 的[mysqld]中加入 replicate-same-server-id
Q.[Note] Slave I/O thread: connected to master ‘test@:3306′,replication
started in log ‘FIRST’ at position 4
[ERROR] Error reading packet from server: Access denied; you need the REPLICATION SLAVE privilege for this operation ( server_errno=1227)
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/90618/viewspace-553552/，如需转载，请注明出处，否则将追究法律责任。