# 启动mysql service mysqld start # cd # 进入mysql命令行 ./mysql -uroot -p123456
use mysql # 赋权限给从数据库 GRANT REPLICATION SLAVE ON *.* to root@192.168.10.112 identified by '123456'; show binary logs; show master status\G; reset master;
更改配置文件
vi /etc/my.cnf #设置主192.168.10.111 server_id=111 #设置主192.168.10.112 server_id=112
# 清空日志文件,同Master cd /usr/local/mysql/data rm -rf mysql-bin.*
change master to master_host='192.168.10.111',master_user='root',master_password='123456',master_port=3306,master_log_file='mysql-bin.000001',master_log_pos=120;
[错误] 其中Slave_IO_Running为NO Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work. [解决] 在副本节点下执行
./mysql -uroot -p123456
show variables like '%server_uuid%'; mv /usr/local/mysql/data/mysql/auto.cnf /usr/local/mysql/data/mysql/auto.cnf.bk # 重启副本节点 systemctl restart mysql