Originally Posted by Toucan
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?
The root user to update the master server must exist if you followed the multiserver setup guides. This user exists only for updates and is not used by ispconfig nor are the details stired in any config file. Please see multiserver guides for details on how the permissions of this root user in the master DB have to be.