View Single Post
Old 1st March 2013, 22:45
Toucan Toucan is offline
Senior Member
Join Date: Dec 2009
Posts: 479
Thanks: 78
Thanked 41 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


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 02:49. Reason: advance on problem
Reply With Quote