全部产品
云市场

账号权限

更新时间:2020-05-20 17:07:28

本文挡主要说明弹性扩展需要用户授予的数据库账号的权限。

MySQL

  • 不创建目标端数据库到源端数据库的回流任务

其中源库的数据库账号需要如下权限:

以账号名是hdm_test进行说明(其中identified by后面的密码,请用户自行设置)

GRANT select on *.* to '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;

  • 需要创建目标端数据库到源端数据库的回流任务

其中源库的数据库账号需要如下权限:

以账号名是hdm_test进行说明(其中identified by后面的密码,请用户自行设置)

GRANT select,insert,update,delete on *.* to '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;