MySQL Forums
Forum List  »  Replication

setup mysql replication on CentOS error
Posted by: tentamen tentamen
Date: May 24, 2010 05:11AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
setup mysql replication on CentOS error
3376
May 24, 2010 05:11AM


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.