you need to be sure you have everything the server needs to be a slave defined in your my.cnf file, especially the relay logs and that the replication slave user is created properly.
On Tue, Aug 19, 2008 at 2:37 AM, Krishna Chandra Prajapati < [EMAIL PROTECTED]> wrote: > Hi, > > I am setting up replication and got the error below > > mysql> change master to master_host='172.20.1.189', master_user='repl', > master_password='pass'; > Query OK, 0 rows affected (0.01 sec) > > mysql> start slave; > ERROR 1200 (HY000): The server is not configured as slave; fix in config > file or with CHANGE MASTER TO > mysql> exit > Bye > [EMAIL PROTECTED] ~]# tail /var/log/mysql/mysqld.log > 080819 12:53:31 [Note] /usr/libexec/mysqld: Normal shutdown > > 080819 12:53:31 InnoDB: Starting shutdown... > 080819 12:53:33 InnoDB: Shutdown completed; log sequence number 0 43665 > 080819 12:53:33 [Note] /usr/libexec/mysqld: Shutdown complete > > 080819 12:53:34 InnoDB: Started; log sequence number 0 43665 > 080819 12:53:34 [Note] /usr/libexec/mysqld: ready for connections. > Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 > Source distribution > 080819 12:55:41 [Warning] Neither --relay-log nor --relay-log-index were > used; so replication may break when this MySQL server acts as a slave and > has his hostname changed!! Please use > '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem. > > > -- > Krishna Chandra Prajapati > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
