错误日志:
120816 11:06:28 [ERROR] Slave I/O: error connecting to master 'admin@XXX.XXX.XXX.XXX:3307' - retry-time: 60 retries: 86400, Error_code: 2003
120816 11:06:28 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000002' at position 6207, relay log './localhost-relay-bin.000001' p osition: 4
120816 11:06:28 [ERROR] Slave I/O: error connecting to master 'admin@XXX.XXX.XXX.XXX:3307' - retry-time: 60 retries: 86400, Error_code: 2003
120816 11:06:28 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000002' at position 6207, relay log './localhost-relay-bin.000001' p osition: 4
解决办法:master端(还是slave端?忘记了) 输入下列命令:
[root@trudy ~]#semanage port -a -t mysqld_port_t -p tcp 3307
[root@trudy ~]#semanage port -l | grep 3306
参考出处:
2、[root@trudy ~]#rm localhost.localdomain.index
导致localhost.localdomain.pid丢失,mysql服务无法重启
解决办法:删除同目录下的mysql-bin.index就好啦!
3、错误日志:
120817 13:51:29 [ERROR] Failed to open the relay log './localhost-relay-bin.000001' (relay_log_pos 4)
120817 13:51:29 [ERROR] Could not find target log during relay log initialization
120817 13:51:39 [ERROR] Failed to open the relay log './localhost-relay-bin.000001' (relay_log_pos 4)
120817 13:51:39 [ERROR] Could not find target log during relay log initialization
解决办法:reset slave,在change master to。。。。,slave start
要是开不了mysql服务,看看是否存在僵尸进程。
若一直配不通,最笨的办法:所有日志文件统统删掉,重启服务再配置!