MySQL/General – The server is not configured as a slave

When setting up replication, MySQL may occasionally throw this error:

ERROR 1200 (HY000): The server is not configured as a slave; fix in config file or with CHANGE MASTER TO”

The troubleshooting steps are simple and usually are the result of a common configuration oversight.

  1. Ensure you have the server_id value configured in the my.cnf
  2. Ensure you have actually executed the appropriate CHANGE MASTER TO statement.
  3. Ensure the server_id value is unique per-server. The best way to do this is by using the ‘long’ value of the server’s IP address. You can get this easily with PHP’s “ip2long()” function.

That’s all there is to it!