View Single Post
  #24  
Old 1st March 2013, 21:45
Toucan Toucan is offline
Senior Member
 
Join Date: Dec 2009
Posts: 479
Thanks: 78
Thanked 40 Times in 34 Posts
Default Slave Unable to connect to mysql server

I updated the master server without problems, but when it came the slave update process it complained:

Unable to connect to mysql server

What should I do please?

running debian lenny

UPDATE

I managed to solve this by creating a new user in the master's user table and gave it permissions for all dbs and tables and then running the update on the slave which worked ok. The problem now is I created a new user and password that i don't actually want to use.

I presume I should have just corrected the passwords for the existing user. Is there a way I can force it to renegotiate permissions with that master again?

Last edited by Toucan; 2nd March 2013 at 01:49. Reason: advance on problem
Reply With Quote