Help, I seem to be running into a problem with replication which up until now has served us well.
We run mysql servers in pairs, with each server in a pair mastering off the other. So for example mysql1 masters off mysql2, which masters off mysql1.
Friday morning one server stopped accepting connections for replication, let's call it mysql2. It's partner, called mysql1, has some log entries which seem on the face of it self explanatory...
040221 15:35:40 Slave I/O thread: error connecting to master '[EMAIL PROTECTED]:3306': Error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' errno: 1045 retry-time: 60 retries: 86400
Try on the slave:
CHANGE MASTER TO MASTER_PASSWORD='correct_password'
I suspect the master.info file somehow got corrupted and it is reading the password incorrectly. Take a look at your master.info file, first the good one to know what it is supposed to look like, and then the bad one.
If that is the case, you could have a more serious problem - the offset and the name of the master log could have also gotten corrupted and you would have to reset the replication altogether.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]