Adding an Instance for Microsoft Azure Database for MySQL

Updated

To manage a database, you can either use an existing instance or add a new instance.

Before You Begin

Configure the permissions to access the Azure resources. Download the CvMySQLRole.json file and use it to apply the permissions.

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. Click Add instance, and then select Cloud DB.

    The Add Cloud DB instance dialog box appears.

  3. From the Select vendor list, select a vendor where you want to create an instance.

  4. From the Database service list, select MySQL.

  5. From the Cloud account list, select a hypervisor.

  6. From the Backup plan list, select a server plan.

  7. From the Instance name list, select an instance.

  8. In the Database user box, type the user name to access the Azure Database for MySQL application.

  9. In the Password box, type the password to access the Azure Database for MySQL application.

  10. If SSL is enabled on the cloud, move the Use SSL options toggle key to the right, and then in the SSL CA file box, enter the SSL CA file path in the proxy computer.

  11. Click Add.

Note: For a Windows client computer, if the instance creation with SSL certificate fails, you can select only the Use SSL options check box, and leave the SSL CA file box blank. For more information, go to Microsoft Documentation, Connecting to server using the MySQL CLI over SSL.

Results

  • The new instance contains a default database group. The default database group includes all the data in the Microsoft Azure Database for MySQL database. You cannot delete the default database group.