MySQL主从分离

# 创建账号 
create user 账号@localhost identified by '密码';

# 账号赋权
 grant replication slave on *.* to 账号@localhost with grant option;

# 刷新权限
 flush privileges;

change master to master_host='主库地址',master_port=主库端口,master_user='主库远程连接账号',master_password='主库远程连接密码',master_log_file='主库的日志文件',master_log_pos=日志同步起始位置;

# 刷新权限
 flush privileges;

# 启动主从同步
start slave;