MySQL主从复制

==================================同步配置================================

主库

1、创建复制账号

grant replication slave on *.* to 'rep'@'10.81.54.141' identified by 'rep';

2、show master status;

从库：

1、CHANGE MASTER TO MASTER_HOST='10.81.244.79',MASTER_USER='rep', MASTER_PASSWORD='rep',MASTER_LOG_FILE='mysql-bin.000002',MASTER_LOG_POS=691;

2、start slave

3、 show slave status\G

================================账号相关====================================

1、创建账号

CREATE USER 'phoneu'@'58.211.107.66' IDENTIFIED BY '33Am0v!Z';

2、授权

GRANT SELECT, INSERT ON mj.* TO 'phoneu'@'58.211.107.66';

执行存储过程增加以下语句：

grant select on mysql.proc to phoneu@10.168.0.3;

3、创建用户加授权--5.7版本官方不建议这么做

grant all privileges on mj.* to 'phoneu'@'58.211.107.66' identified by '33Am0v!Z';

flush privileges;

4、设置与更改用户密码

SET PASSWORD FOR 'phoneu'@'58.211.107.66' = PASSWORD("123456");

5、撤销用户权限

REVOKE SELECT ON mj.* FROM 'phoneu'@'58.211.107.66';

6、删除用户

DROP USER 'phoneu'@'58.211.107.66';

7、查看用户授权

show grants for 'phoneu'@'58.211.107.66';