mysql主从配置

master：
vi /etc/my.cnf
[mysqld]
log-bin=mysql-bin
server-id=1
binlog-ignore-db = mysql,information_schema,sys,performance_schema,undolog

service mysqld restart 

slave:
vi /etc/my.cnf
[mysqld]
server-id=2

service mysqld restart

 
master:
mysql > grant replication slave on *.* to ‘rep’@‘192.168.253.%’ identified by ‘123456’;

master:
show master status;

slave:
CHANGE MASTER TO
MASTER_HOST='192.168.77.136',
MASTER_USER='liu',
MASTER_PASSWORD='liu',
MASTER_LOG_FILE='mysql-bin.000003',
master_log_pos=351;

show slave status;

start slave;