View Single Post
Old 5th April 2012, 10:41
till till is online now
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,977
Thanks: 825
Thanked 5,369 Times in 4,216 Posts

Could it be that there are other security settings except username and password?
Mysql uses a security concept which takes the IP address in account as I explained above. If you want to test the mysql connection, use the mysql command and for the test you have to run it on the salve and not on the amster or any other server.

So to test the connection, login on the shell of the slave server and issue this command:

mysql -h master.server.tld -u root -p

replace master.server.tld with the hostname of your master server.

Another important thing is that you edited the /etc/hosts files eaxctly as described in the installation instructions on all servers that belong to the clusetr. E.g. sv1.server.tld

is ok while: sv1.server.tld sv1

may cause the mysql connect to fail.
Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from
Reply With Quote