==================================同步配置================================
主库
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';
