Monday, June 28, 2010

mysql -- Error reading master configuration

If you are trying to setup and slave and you get this error message in the error log repeatedly, it maybe that the master configuration isn't correct. You may need to try resetting the slave with:

mysql> reset slave;
Query OK, 0 rows affected (0.00 sec)

Then reissue the change master command to setup the slave:

mysql> CHANGE MASTER TO
-> MASTER_HOST='xxx.xxx.xxx.xx',
-> MASTER_USER='xxxxxxxx',
-> MASTER_PASSWORD='xxxxxxx',
-> MASTER_PORT=3306,
-> MASTER_LOG_FILE='mysql-bin.000003',
-> MASTER_LOG_POS=1372;
Query OK, 0 rows affected (0.01 sec)

Restart the slave:

mysql> start slave;
Query OK, 0 rows affected (0.00 sec)

No comments:

Post a Comment