Friday, October 25, 2013

Replication in MySQL : From slave : unable to connect Master 10.184.0.10

Recently one my colleague was setting up MySQL replication through phpMyAdmin. When connecting Master through Slave, got error like  "unable to connect Master : 10.84.1.20"


Slave : Unable to connect Master : 10.84.1.20


SOLUTION
  I was gone through both Master and Salve my.cnf file. both Master and Slave   bind-address was pointing to the localhost. Modify  bind-address   localhost to 0.0.0.0 was solved the issues. 

from
 bind-address = 127.0.0.1
to
 bind-address = 0.0.0.0





No comments: