im trying to setup mysql slave but the things is it wont start because of this errror:
--> ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO after some testing.. i saw the server-id = 0 through > show variables like 'server_id' went to check server-id parameter in /etc/my.cnf grep server-id /etc/my.cnf #server-id = 2 server-id = 2 -- its good.. ls -l ~/my.cnf -- file not found.. print_defaults mysqld result --server-id=2 -- its good but again > show variables like server_id is showing "0" what i had to do is set global parameter in mysqld cli w/c is not a good thing.. additional info: Default options are read from the following files in the given order: /etc/my.cnf ~/.my.cnf /etc/my.cnf is there anyway to trace why server-id = 0?