— mysql 搭建主从数据库
安装:https://blog.csdn.net/qq_37598011/article/details/93489404
权限:https://blog.csdn.net/J080624/article/details/78802260
主从:https://blog.csdn.net/qq_38727626/article/details/82632649
create user ‘slave_admin’@‘%’ identified by ‘root’;
grant all privileges on . to ‘slave_admin’@‘%’ identified by ‘root’ ;
grant select on . to ‘slave_admin’@‘%’ identified by ‘root’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
使用主从:https://blog.csdn.net/qq_38727626/article/details/82632649 配置
change master to master_host=‘127.0.0.1’,master_user=‘slave_admin’,master_password=‘root’,MASTER_PORT = 3309, master_log_file=‘binlog.000002’,master_log_pos=4488;