主从复制配置
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';