MySQL Forums :: Replication :: setup mysql replication on CentOS error


Advanced Search

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 3340 tentamen tentamen 05/24/2010 05:11AM
Re: setup mysql replication on CentOS error 1091 Rick James 05/25/2010 08:40AM
Re: setup mysql replication on CentOS error 1015 tentamen tentamen 05/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.