David Campbell wrote: > [EMAIL PROTECTED] wrote: >> I'm in process of upgrading a master server from 4.0.24-log to 5.0.22-log >> in a single master-slave environment. I've previously upgraded the slave >> to 5.0.22-log and restarted replication without issue. >> >> The current master is running on RH9 and the slave is running on CentOS 5, >> which is what I'm trying to upgrade the master to, also. >> >> After synchronizing the databases, I've run 'reset master' and 'reset >> slave' on their respective servers, then 'change master to...' on the >> slave, but 'show slave status' always displays: 'Slave_IO_Running: No' >> >> And here is the log entry from the slave: >> >> 071113 9:16:19 [ERROR] Slave I/O thread: error connecting to master >> '[EMAIL PROTECTED]:3306': Error: 'Lost connection to MySQL server
>> during query' errno: 2013 retry-time: 60 retries: 86400 >> 071113 9:17:35 [Note] Slave I/O thread killed while connecting to master> > grep deny /etc/hosts.deny > Dave Dave: There are no uncommented entries in /etc/hosts.deny Baron: The all servers have a unique server-id in their respective my.cnf's When I try to connect directly from the slave to the new master, I get: ERROR 2003 (HY000): Can't connect to MySQL server on '1xx.1xx.1xx.xx' (113) I'll make a super user to test... David
