MySQL主从复制参考 -JZTXT

https://blog.csdn.net/qq_52061700/article/details/126979017

https://www.jb51.net/article/180748.htm

相关执行命令：
mysqldump -uroot -p密码 --opt -R 数据库名称> /opt/app/bak.sql; -- 主数据库备份，用来导入从数据库，保证两边数据一致

CREATE USER copyoperator IDENTIFIED WITH 'mysql_native_password'  BY '密码';

GRANT REPLICATION SLAVE ON *.* TO copyoperator;

FLUSH PRIVILEGES;

change master to master_host='主数据库ip地址',master_user='copyoperator',master_password='密码',master_log_file='mysql-bin.000001',master_log_pos=61391;

end