> Software > Protect > Databases > Azure > Azure Database for MySQL > Getting Started > Permissions

User Account Permission Requirements for Microsoft Azure Database for MySQL

To back up and restore MySQL data on an Azure 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;

  • You do not require a root user account to install or operate the export-based backup and recovery solution. Use a non-root user account with sudo privileges for the installation and operations. For more information, see installation of UNIX agents by a non-root user with sudo privileges.

×

Loading...