MySQL Replication

Discussion in 'Server Operation' started by dclardy, Jan 10, 2011.

  1. dclardy

    dclardy Member


    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.
  2. Torsson

    Torsson Member

    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 =
    then try with changing it to
    #bind-address =

    and se if that helps.
  3. BorderAmigos

    BorderAmigos New Member

    Hmm... Make sure the port isn't blocked by a firewall at either master or slave?

    Master /etc/mysql/my.conf relevant part...
    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...
    #### For Database Replication
    ### from mysql_database_replication_p2
    replicate-do-db = db1
    replicate-do-db = db2
    replicate-do-db = ...
    Last edited: Jan 14, 2011
  4. BorderAmigos

    BorderAmigos New Member

    ^^^^ 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.

Share This Page