MYSQL Replication problem

[Hal Burgiss]

This is a simple one to one set up. Slave is 8.04LTS server, fully
upgraded, and the master is CentOS mysql 5.0. I have done this step by
step using 4 different HOWTOs and I get the same result: it *seems*
to work, in that there are no errors or obvious complaining, but I
always get:

           Slave_IO_Running: No
           Slave_SQL_Running: Yes

Always. It just sits in that state and there is no replicating going
on.

mysql> show slave status\G;
*************************** 1. row ***************************
             Slave_IO_State: 
                Master_Host: db.example.com
                Master_User: slave
                Master_Port: 3306
              Connect_Retry: 120
            Master_Log_File: mysql-bin.000001
        Read_Master_Log_Pos: 585161
             Relay_Log_File: mysqld-relay-bin.000001
              Relay_Log_Pos: 98
      Relay_Master_Log_File: mysql-bin.000001
           Slave_IO_Running: No
          Slave_SQL_Running: Yes
            Replicate_Do_DB: 
        Replicate_Ignore_DB: 
         Replicate_Do_Table: 
     Replicate_Ignore_Table: mysql.user
    Replicate_Wild_Do_Table: 
Replicate_Wild_Ignore_Table: 
                 Last_Errno: 0
                 Last_Error: 
               Skip_Counter: 0
        Exec_Master_Log_Pos: 585161
            Relay_Log_Space: 98
            Until_Condition: None
             Until_Log_File: 
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File: 
         Master_SSL_CA_Path: 
            Master_SSL_Cert: 
          Master_SSL_Cipher: 
             Master_SSL_Key: 
      Seconds_Behind_Master: NULL

mysql> show slave status\G;
*************************** 1. row ***************************
             Slave_IO_State: 
                Master_Host: garth2.resultsbydesign.com
                Master_User: slave
                Master_Port: 3306
              Connect_Retry: 120
            Master_Log_File: mysql-bin.000001
        Read_Master_Log_Pos: 585161
             Relay_Log_File: mysqld-relay-bin.000001
              Relay_Log_Pos: 98
      Relay_Master_Log_File: mysql-bin.000001
           Slave_IO_Running: No
          Slave_SQL_Running: Yes
            Replicate_Do_DB: 
        Replicate_Ignore_DB: 
         Replicate_Do_Table: 
     Replicate_Ignore_Table: mysql.user
    Replicate_Wild_Do_Table: 
Replicate_Wild_Ignore_Table: 
                 Last_Errno: 0
                 Last_Error: 
               Skip_Counter: 0
        Exec_Master_Log_Pos: 585161
            Relay_Log_Space: 98
            Until_Condition: None
             Until_Log_File: 
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File: 
         Master_SSL_CA_Path: 
            Master_SSL_Cert: 
          Master_SSL_Cipher: 
             Master_SSL_Key: 
      Seconds_Behind_Master: NULL
1 row in set (0.00 sec)


mysql> show processlist\G;
*************************** 1. row ***************************
     Id: 13
   User: system user
   Host: 
     db: NULL
Command: Connect
   Time: 648
  State: Has read all relay log; waiting for the slave I/O thread to update it
   Info: NULL
*************************** 2. row ***************************
     Id: 14
   User: noname
   Host: localhost
     db: NULL
Command: Query
   Time: 0
  State: NULL
   Info: show processlist

slave config:
==============

server-id      = 2
##log_bin           = /var/log/mysql/mysql-bin.log
 master-host=db.example.com
 master-port=3306
 master-user=slave
 master-password=somethinghere
 master-connect-retry=60
 replicate-ignore-table=mysql.user


The both systems are open to each other via port 3306. I can remotely
connect to the master using the slave's credentials just fine. Logging
is on, on the master. 

There is plenty helpful info via google to make sure Slave_IO_Running
is YES, but scant little to say about what if its not. I can't believe
4 HOWTOs are all wrong on this. Ideas? 


-- 
Hal