All, I have followed the tutorial to setup replication, but it is not working properly. I am getting an error. error connecting to master '[email protected]:3306' Any ideas? I have been trying to get this working all day.
Just a long shot.. Check that you dont have bind-address to localhost in your mysql config (my.conf) if your bind-address is like this bind-address = 127.0.0.1 then try with changing it to #bind-address = 127.0.0.1 and se if that helps.
Hmm... Make sure the port isn't blocked by a firewall at either master or slave? Master /etc/mysql/my.conf relevant part... Code: log-bin = /var/log/mysql/mysql-bin.log server-id = 1 binlog-do = db1 binlog-do = db2 binlog-do = ... Slave /etc/mysql/my.conf relevant part... Code: #### For Database Replication ### from http://www.howtoforge.com mysql_database_replication_p2 server-id=2 master-host=nnn.nnn.nnn.nnn master-user=slave_user_name master-password=xxx master-connect-retry=60 relay-log=mysqld-relay-bin replicate-do-db = db1 replicate-do-db = db2 replicate-do-db = ...
^^^^ Is venritz a bot of some sort? Seems to have several posts that are just cut and pastes from wikipedia or similar and don't really say anything.
