How to Create Azure Database for MySQL Server in Microsoft azure.

Azure Database for MySQL is a relational database service in the Microsoft cloud based on the MySQL Community Edition (available under the GPLv2 license) database engine, versions 5.6, 5.7, and 8.0.

Azure Database for MySQL delivers:

  1. Built-in high availability.
  2. Data protection using automatic backups and point-in-time-restore for up to 35 days.
  3. Database engine to keep the service secure and up to date.
  4. Predictable performance, using inclusive pay-as-you-go pricing.
  5. Elastic scaling within seconds.
  6. Cost optimization controls with ability to stop/start server.


  • Login to azure portal
  • Click on All Services.
  • Select Azure Databases for MySQL Server.


Fig 1


  • Click on Create.


Fig 2


  • Select  an option Azure Database for MySQL database deployment.
  • If Select Single Server then click on Create option.


Fig. 3


  • On Basics tab provide the following values:-


  • Subscription: An Azure subscription grants you access to Azure services.
  • Resource group name: A resource group is a collection of resources.
  • Provide the Server name.
  • Select Data Source (Set the backup for MySQL server).
  • Select Location & MySQL Version.
  • Select compute + Storage plan as per requirements.
  • Provide the Administrator details like admin username & password.
  • Click on Next Additional Settings.


Fig. 3Fig. 4


  • At Additional settings,Add a second layer of encryption for your data using a different encryption algorithm which gives additional data protection
  • Click on Tags.


Fig. 5


  • On Tags Tab provide the tag name and value for Azure Database for MySQL Server.
  • Click Next on Review + Create.


Fig. 6


  • If you get a message “Validation passed”.
  • Then click on Create.




  • After some time, you will see a message as “Your deployment is ready”.
  • Click on “Go to resources” & You can see that the Azure Database for MySQL Server is there with the name we provide.


Leave a Reply