mysql master slave

MYSQL Master 

mysql> use mysql

mysql> update user set password=PASSWORD("redhat") where User='root'

flush privileges;

mysql> GRANT REPLICATION SLAVE ON *.* TO 'slave'@'%' IDENTIFIED BY 'slave';

mysql> flush privileges;

mysql> SHOW MASTER STATUS;

+------------------+----------+--------------+------------------+

| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |

+------------------+----------+--------------+------------------+

| mysql-bin.000001 |     2707 | |               |

+------------------+----------+--------------+------------------+

1 row in set (0.00 sec)

"/etc/my.cnf"

server-id = 1

log-bin = mysql-bin

slave

MYSQL SLAVE

mysql> use mysql;

mysql> update user set password=PASSWORD("redhat") where User='root';

mysql> flush privileges;

"/etc/my.cnf"

server-id = 2

slave-skip-errors = all

master-host=192.168.68.142

master-user=slave

master-password=slave

master-connect-retry=60

mysql>CHANGE MASTER TO MASTER_HOST='192.168.68.141', MASTER_USER='slave', MASTER_PASSWORD='slave', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=2389;

flush privileges;

START SLAVE;