Bruce Dembecki wrote:
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]



Reply via email to