Creating And Configuring A MySQL Server On The Azure Portal

This article demonstrates how to create a MySQL database on the Azure Portal.

Introduction

In this article, I am going to show you how to configure a MySQL Server on the Azure portal, and also how to configure the connection security with the system.

Prerequisites

An Azure Account. (If you don't have one,  get one through this Link).

What is MySQL in Azure?

Azure Database for MySQL is a relational database service to provide a MySQL community database engine with Microsoft Cloud Services. It also provides many advantages that are featured in MS SQL.

Follow these steps to create the MySQL in Azure portal.

Step 1

Sign in to the Azure portal.

Step 2

Select the New+ button on the left side corner of the Azure portal, then choose the databases, and also, click the Azure Database for MySQL.

 

Step 3

In the MySQL Server creation blade, enter the unique server name. Then, choose the desired subscription you have and create a new resource group. You must have entered the server admin name and also have given the password for the MySQL Server. Then, choose the location nearest to you.

 

For the version, choose the MySQL version you want and also choose the desired pricing tier for your server and press OK and click CREATE to create the MySQL server.

 

Step 4

After successful deployment, our MySQL Server is shown, with its detailed overview in the Overview tab.

 
Step 5

Then, we want to configure the Firewall to connect to our client PC. By default, it rejects the connection to the server and the database. Click the "Connection Security" and then click "Add My IP" to add your IP address to MySQL Server. Click "Save" button. Your IP is shown under the Firewall rules.



Conclusion

Finally, our Azure Database for MySQL Server is created and then it is configured with our client system. I hope you learned how to create and configure the MySQL Server in the Azure Portal.