Azure Database for MySQL - Mini Project: Build & Apply

Azure Database for MySQL Setup and Configuration

📖 Scenario: You are setting up a simple Azure Database for MySQL server for a small business application. This database will store customer information securely and allow the application to connect and query data.

🎯 Goal: Build an Azure Database for MySQL server with basic configuration, including resource group, server creation, firewall rule, and database creation.

📋 What You'll Learn

Create a resource group named myResourceGroup in the eastus region.

Create an Azure Database for MySQL server named mymysqlserver with admin username mysqladmin and password MyP@ssw0rd123.

Set the server version to 5.7 and configure the SKU to B_Gen5_1.

Add a firewall rule named AllowMyIP to allow access from IP 0.0.0.0 to 255.255.255.255.

Create a database named mydatabase on the MySQL server.

💡 Why This Matters

🌍 Real World

Setting up a managed MySQL database in Azure is common for web applications, mobile apps, and backend services that require reliable and scalable data storage.

💼 Career

Cloud engineers and database administrators often need to provision and configure managed database services like Azure Database for MySQL to support application development and deployment.

1

Create the Resource Group

Write the Azure CLI command to create a resource group named myResourceGroup in the eastus region.

Azure

# Your Azure CLI command here to create the resource group

Need a hint?

Use az group create with --name and --location options.

2

Create the MySQL Server

Write the Azure CLI command to create an Azure Database for MySQL server named mymysqlserver in resource group myResourceGroup with admin username mysqladmin, password MyP@ssw0rd123, server version 5.7, SKU B_Gen5_1, and location eastus.

Azure

az group create --name myResourceGroup --location eastus
# Your Azure CLI command here to create the MySQL server

Need a hint?

Use az mysql server create with all required parameters.

3

Add a Firewall Rule

Write the Azure CLI command to add a firewall rule named AllowMyIP to the MySQL server mymysqlserver in resource group myResourceGroup allowing access from IP 0.0.0.0 to 255.255.255.255.

Azure

az group create --name myResourceGroup --location eastus
az mysql server create --resource-group myResourceGroup --name mymysqlserver --admin-user mysqladmin --admin-password MyP@ssw0rd123 --sku-name B_Gen5_1 --version 5.7 --location eastus
# Your Azure CLI command here to add the firewall rule

Need a hint?

Use az mysql server firewall-rule create with the correct parameters.

4

Create the Database

Write the Azure CLI command to create a database named mydatabase on the MySQL server mymysqlserver in resource group myResourceGroup.

Azure

az group create --name myResourceGroup --location eastus
az mysql server create --resource-group myResourceGroup --name mymysqlserver --admin-user mysqladmin --admin-password MyP@ssw0rd123 --sku-name B_Gen5_1 --version 5.7 --location eastus
az mysql server firewall-rule create --resource-group myResourceGroup --server mymysqlserver --name AllowMyIP --start-ip-address 0.0.0.0 --end-ip-address 255.255.255.255
# Your Azure CLI command here to create the database

Need a hint?

Use az mysql db create with the correct parameters.