mysql-1赋予mysql-2可使用的权限账号 ( 用户名:happy,远程客户端可访问IP:192.168.168.131,密码:888 ):
mysql> grant replication slave on *.* to happy@192.168.168.131 identified by '888';
显示mysql-1的master信息:
mysql> show master status;
mysql-2赋予mysql-1可使用的权限账号 ( 用户名:happy,远程客户端可访问IP:192.168.168.130,密码:888 ):
mysql> grant replication slave on *.* to happy@192.168.168.130 identified by '888';
显示mysql-2的master信息:
mysql> show master status;