主从复制配置

主从复制配置

stop slave;

change master to
master_host='127.0.0.1',
master_user='root1',
master_password='123456',
master_port=3306,
master_log_file='mysql-bin.000004',
master_log_pos=154;

start slave;

show slave status;

 

新创建一个账号：

create user 'root1'@'127.0.0.1' identified by '123456';
grant replication slave on *.* to 'root1'@'127.0.0.1' identified by '123456';