> Commvault Cloud > Database > Azure > Azure Database for MySQL > Getting Started

System Requirements for Microsoft Azure Database for MySQL

Verify that your environment meets the system requirements for MySQL.

Azure Cloud

Verify that the following ports are open:

  • Inbound rules for MySQL instance

    • 3306 to allow connections from backup gateway

  • Outbound rules on backup gateway

    • 443 to management.azure.com

    • 3306 for MySQL to connect to MySQL endpoints

Supported MySQL Versions

  • MySQL 8.0.x

  • MySQL 5.7.x

  • MySQL 5.6.x

Note

To back up and restore data using MySQL version 8 on Windows, install Microsoft Visual C++ libraries.

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;

SSL and TLS Support

SSL is supported for MySQL version 5.7 and later. The supported TLS versions to create Azure SSL encrypted MySQL instances are TLS 1.0, 1.1 and 1.2.

Loading...