I am looking into setting up replication in a production environment but currently this is on two test machines. I am following the documentation at
http://dev.mysql.com/doc/refman/5.0/...ion-howto.html but I am unable to get past "16.1.1.10 Setting the Master Configuration on the Slave". When I do the CHANGE MASTER TO I am getting a syntax error for some reason. What am I doing wrong? These servers run "CentOS release 5.5 (Final)" and "MySQL 5.0.77-log Source distribution" installed via yum. The only changes from default are that I created a single database on the master before doing the table lock and dump, then everything else has been done exactly to what the documentation states, but is still failing. Any help is appreciated but I'm no database expert, just a Linux admin.
The option skip-networking is not in the config file on either server and neither one runs SELinux or any firewall.
mysql> CHANGE MASTER TO
-> MASTER_HOST='192.168.1.220'
-> MASTER_USER='repl'
-> MASTER_PASSWORD='removed'
-> MASTER_LOG_FILE='mysql-bin.000002'
-> MASTER_LOG_POS='98';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MASTER_USER='repl'
MASTER_PASSWORD='removed'
MASTER_LOG_FILE='mysql-bin.00' at line 3