MySQL实例间的双向同步 数据库 所需权限 参考赋权语句 源库 正向同步(源库A同步至目标库B)A库所需权限: 对MySQL库的SELECT权限。 对待迁移库的SELECT, EXECUTE, EVENT,TRIGGER权限。 部分全局权限: REPLICATION CLIENT REPLICATION SLAVE SHOW VIEW SHOWROUTINE PROCESS 如果是整实例迁移,需要对所有数据库的查询权限。 反向同步(目标库B同步至源库A)A库所需权限为以下全局权限: ALTER ALTER ROUTINE REATE CREATE ROUTINE CREATE TEMPORARY TABLES CREATE USER CREATE VIEW DELETE DROP EVENT EXECUTE INDEX INSERT PROCESS REFERENCES SELECT SHOW DATABASES SHOW VIEW TRIGGER UPDATE 正向同步(源库A同步至目标库B)A库参考赋权语句: GRANT SELECT ON mysql. TO '迁移账号'@'%'; GRANT SELECT, EXECUTE, EVENT, TRIGGER ON 待迁移的库. TO '迁移账号'@'%'; GRANT REPLICATION CLIENT, REPLICATION SLAVE, SHOW VIEW, SHOWROUTINE,PROCESS ON . TO '迁移账号'@'%'; 反向同步(目标库B同步至源库A)A库参考赋权语句: GRANT ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE USER, CREATE VIEW, DELETE, DROP, EVENT, EXECUTE, INDEX, INSERT, PROCESS, REFERENCES, SELECT, SHOW DATABASES, SHOW VIEW, TRIGGER, UPDATE ON . TO '迁移账号'@'%'; 目标库 同上 同上