MySQL 主从部署

主库配置

创建用户

CREATE USER 'replication'@'%' IDENTIFIED BY '123456';

授权

GRANT REPLICATION SLAVE ON *.* TO 'replication'@'%';

刷新权限

FLUSH PRIVILEGES;