Slave settings not working I have this machine as slave. Below is the command I ran and stuck. I done the change on the config file and set the id=2 too. Anything else I am missing here?

slave start; 
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log 
mysql&gt; change master to MASTER_HOST='192.168.1.15', MASTER_USER='replication1', MASTER_PASSWORD='*******',MASTER_LOG_FILE='mysql-bin.000001'; ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log ?


Below is the results of 

show master status\G
*************************** 1. row ***************************
            File: mysql-bin.000001
        Position: 98
    Binlog_Do_DB: fms,sms
Binlog_Ignore_DB:
1 row in set (0.00 sec)


show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.1.15
                  Master_User: replication1
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000001
          Read_Master_Log_Pos: 98
               Relay_Log_File: mysqld-relay-bin.000002
                Relay_Log_Pos: 243
        Relay_Master_Log_File: mysql-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB: fms
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 98
              Relay_Log_Space: 399
              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: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
1 row in set (0.00 sec)
I noticed you did not specify the MASTER_LOG_POS in the CHANGE MASTER TO command.

Another problem could be this:

When you set up MySQL Replication, you have to explicitly set this in /etc/my.cnf

on the master:

[mysqld]
server-id=1


and this on the Slave

[mysqld]
server-id=2


Then CHANGE MASTER TO can work

Since the Master is MySQL 5.0.67 and you loaded the same data into the Slave, here is the CHANGE MASTER TO command you need:

change master to
MASTER_HOST='192.168.1.15',
MASTER_USER='replication1',
MASTER_PASSWORD='*******',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=98;


Here is something you need to know fot setting up other slaves


The Master must be the same version as the Slave or older.
The starting position for any empty Master is

107 for MySQL 5.5
106 for MySQL 5.1
98 before MySQL 5.1



Now you have replication working, take note of the following


Relay_Log_Space is 399
Exec_Master_Log_Pos is 98


Do the following:


Run this command on the Master: CREATE DATABASE rolando;
Do SHOW SLAVE STATUS\G on the Slave
Do SHOW DATABASES; on the Slave


What results should you have?


Relay_Log_Space should be greater than 399
Exec_Master_Log_Pos should be greater than 98
The database rolando should appear in the SHOW DATABASES; on the Slave


If this happens, congratulations !!! Replication is working !!!

From here, you just have to monitor


Slave_IO_Running (make sure it is Yes)
Slave_SQL_Running (make sure it is Yes)
Seconds_Behind_Master (should be zero, long running queries make it increase until all queries are processed)