# User Account Permission Requirements for Alibaba Cloud ApsaraDB RDS for MySQL

To back up and restore MySQL data on an Alibaba application, verify that your environment has the required user account permissions.

## User Account Requirements

The MySQL user account must have the following minimum permissions to perform cloud based backup and restore operations using dump-based solutions:

SELECT INSERT UPDATE DELETE CREATE DROP RELOAD PROCESS REFERENCES ALTER SHOW DATABASES CREATE TEMPORARY TABLES INDEX | LOCK TABLES EXECUTE REPLICATION SLAVE REPLICATION CLIENT CREATE VIEW SHOW VIEW CREATE ROUTINE ALTER ROUTINE CREATE USER EVENT TRIGGER ON

Example:

CREATE USER 'new_master_user'@'%' IDENTIFIED BY 'StrongPassword!';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'new_master_user'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

## Alibaba User Permissions

Download the alicloud_min_permission_policy.json file and use it on the Alibaba command line to apply all of the required permissions for backups and restores.

×

Loading...