AZURE CLOUD PLATFORM -Azure Database For MySQL Server (Article 11)

Hi! Guys welcome to the continuous article set of my Azure cloud platform based on the shared cloud architecture. This is my 11th article. You can visit my previous articles from the below links:

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:

  • Built-in high availability with no additional cost.
  • Predictable performance, using inclusive pay-as-you-go pricing.
  • Scale as needed within seconds.
  • Secured to protect sensitive data at-rest and in-motion.
  • Automatic backups and point-in-time-restore for up to 35 days.
  • Enterprise-grade security and compliance.

These capabilities require almost no administration and all are provided at no additional cost. They allow us to focus on rapid app development and accelerating our time to market rather than allocating precious time and resources to managing virtual machines and infrastructure. In addition, we can continue to develop our application with the open-source tools and platform of our choice to deliver with the speed and efficiency our business demands, all without having to learn new skills.

Come and let’s create MySQL database server…..

Click Create Resource button in the side navigation button and search for Azure Database for MySQL and select create.

Then fill out the application form and create your MySQL Server.

To configure a server-level firewall rule,

Select your MySQL server.

Then in the side navigation panel, select the option Connection Security.

Now select Add current client IP address and then select Save. You can add additional IPs or provide an IP range to connect to your server from those IPs.

Now let’s connect to Azure Database for MySQL server using MySQL command-line client.

First launch Azure Cloud Shell in the portal by clicking the highlighted icon on the top-left side.

Above option you can select either Bash or Powershell. When you click them, if you don’t have a storage account, then it will as us to create a storage account. Because Azure Cloud Shell requires an Azure file share to persist files. If you haven’t then click create a storage account.

After that you will come up with the following command line.

Run the following command on Azure Cloud Shell terminal. Replace values with your actual server name and admin user login name.

mysql — host=mydemoserver.mysql.database.azure.com — user=myadmin@mydemoserver -p

After you enter the above command correctly with the password, you can see the following structure of commands.

Now i am going to create a database named student. So Type,

CREATE DATABASE student;

I use this database for my upcoming works. SO to do that type,

USE student;

Finally type quit, and then select the Enter key to quit MySQL.

This is the end of Article 11 and hope you get a brief idea about Azure Database for MySQL Server and how to create it practically.

Will see you on my next article Azure Storage

Thank You!

B.Sc in Software Engineering (Honors)