ERROR HY000: The server is not configured as slave; Fix in config file or with change MASTER to
First verify that your re-slave server is performing the following to configure the slave server.
Change master to master_host= ' Master_host ', master_user= ' you_user_name ', master_password= ' You_master_user_ Password ', master_log_file= 'mysqld-bin.000001 ', master_log_pos=98;
(Master_log_file and Master_log_pos) is where you can run show Master status on the server; To get.
Next, verify that the server_id on slave and master are correct. You can run SHOW VARIABLES like ' server_id ' on slave and master respectively; To see if the server_id is the same as the one you configured.
Modify the configuration file differently. To edit/etc/my.conf from the server, add server_id=x at the bottom of [mysqld], and the X value is the same as the primary server server_id, restart the server.
This article is from the "Godben" blog, make sure to keep this source http://godben.blog.51cto.com/8919725/1711172
MySQL 5.6.19 Master-Slave Server-id does not take effect, the server is not configured as slave