title: MySQL replication error 2003
body: <p>I'm trying to establish replication between two linux boxes.</p>
  
  <p>My master and slave are on LAN, both can ping each other and can telnet ip 3306, meaning the mysql ports are open on both ends.</p>
  
  <p>I created a replication user on master and on slave:</p>
  
  <pre><code>change master to master_host ='master_ip';
  change master to master_user ='replicator';
  change master to master_password ='password';
  </code></pre>
  
  <p>Master gives this when showing master status:</p>
  
  <pre><code>+------------------+----------+--------------+------------------+
  | File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
  +------------------+----------+--------------+------------------+
  | mysql-bin.000001 |   546050 |              |                  |
  +------------------+----------+--------------+------------------+
  1 row in set (0.01 sec)
  </code></pre>
  
  <p>I'm getting the following error on show slave status:</p>
  
  <pre><code>Slave_IO_Running: Connecting
  Slave_SQL_Running: Yes
  ..
  Last_IO_Errno: 2003
  Last_IO_Error: error connecting to master 'replicator@master_ip:3306' - retry-time: 60  retries: 86400
  </code></pre>
  
  <p>Anyone has any ideas as to what this could be, or any other info you may need?</p>
  
  <p>EDIT:</p>
  
  <p>On the slave the last line of show slave status\G reads:</p>
  
  <p>Master_Server_Id: 0</p>
  
  <p>Shouldn't that say 1 as that is master's ID?</p>