Amazon RDS for MySQL

You can use the Commvault software to back up and restore a MySQL server instance that is hosted in the Amazon RDS cloud.

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;

Loading...