I had some trouble configuring a MySQL 5.5 Server as Replication Slave as I c&p’ed the configuration data into the slaves’s my.cnf: MySQL did not not start.
A look into the error log showed:
[ERROR] /opt/lampp/sbin/mysqld: unknown variable 'master-host=1$ [ERROR] Aborting
Obviously the Replication Master data cannot be set in slave my.cnf for MySQL 5.5 Server, though the my.cnf sample files still proposes this.
To define the Replication Master, connect through a shell to your MySQL server and enter:
mysql> CHANGE MASTER TO MASTER_HOST='N.N.N.N', MASTER_PORT=N, MASTER_USER='NAME', MASTER_PASSWORD='PASSWORD';
This will create a master.info file, where this data and information about the master bin-log and the log position is stored.
Start the replication:
mysql> START SLAVE;
Confirm your configuration:
mysql> SHOW SLAVE STATUS \G;