GRANT REPLICATION SLAVE,RELOAD,SUPER ON *.* TO ‘backup‘@‘192.168.0.108‘ IDENTIFIED BY ‘abcd1234‘;

vi /etc/my.cnf--------------server_id=101log-bin=mysql-bin

service mysqld restart

mysql -uroot -ppassword

show master status;

vi /etc/my.cnf--------------server_id=108log-bin=mysql

service mysqd restart

mysql -uroot -ppassword

change master to master_host=‘192.168.0.101‘,master_user=‘backup‘,master_password=‘abcd1234‘,master_log_file=‘mysql-bin.000003‘,master_log_pos=670;

start slave