1、错误日志：
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服务，看看是否存在僵尸进程。
若一直配不通，最笨的办法：所有日志文件统统删掉，重启服务再配置！
阅读(2805) | 评论(0) | 转发(0) |
