setup mysql replication on CentOS error
hi,
im using mysql 5.0.77 on centos 5.4 at both 2 server.
now, i want setup master-slave replication.
at master, i edit /etc/my.cnf file
log-bin = /var/log/mysql/mysql-bin.log
binlog-do-db=exampledb
server-id=1
after restart mysql, i create mysql user with replication privileges
STOP SLAVE;
GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'%' IDENTIFIED BY 'slave_password';
FLUSH PRIVILEGES;
next, i check master status, but it show empty set
USE exampledb;
FLUSH TABLES WITH READ LOCK;
SHOW MASTER STATUS;
Empty set (0.00 sec)
replication dont work?
help me,
thanks
Quan
Subject
Views
Written By
Posted
setup mysql replication on CentOS error
4227
May 24, 2010 05:11AM
1362
May 25, 2010 08:40AM
1163
May 25, 2010 08:18PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.