本文主要说明容灾建设功能需要用户授予的数据库账号的权限。

RDS MySQL

其中源端实例和目标实例的数据库账号需要如下权限:

以账号名是hdm_test进行说明(其中identified by后面的密码,请用户自行设置)GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON . TO ‘hdm_test’@’%’ identified by ‘密码’ WITH GRANT OPTION;

自建MySQL

其中源端实例和目标实例的数据库账号需要如下权限:

以账号名是hdm_test进行说明(其中identified by后面的密码,请用户自行设置)GRANT SUPER, SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON . TO ‘hdm_test’@’%’ identified by ‘密码’ WITH GRANT OPTION;