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)

Popular posts from this blog

Ansible - Task executed multiple times due to a Broken Pipe

Vyatta -- SIP Connection Tracking for VOIP

tcpdump - Show only http headers