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

主庫(kù)

1、創(chuàng)建復(fù)制賬號(hào)

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

2、show master status;

從庫(kù)：

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

================================賬號(hào)相關(guān)====================================

1、創(chuàng)建賬號(hào)

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

2、授權(quán)

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

執(zhí)行存儲(chǔ)過(guò)程增加以下語(yǔ)句：

grant select on mysql.proc to phoneu@10.168.0.3;

3、創(chuàng)建用戶(hù)加授權(quán)--5.7版本官方不建議這么做

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

flush privileges;

4、設(shè)置與更改用戶(hù)密碼

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

5、撤銷(xiāo)用戶(hù)權(quán)限

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

6、刪除用戶(hù)

DROP USER 'phoneu'@'58.211.107.66';

7、查看用戶(hù)授權(quán)

show grants for 'phoneu'@'58.211.107.66';