Playing with MySQL Server in Azure | Scribe

Playing with MySQL Server in Azure

  • Hafeez Baig |
  • 22 steps |
  • 2 minutes
  • AzureAzure
information ordinal icon
Refer to this guide to learn how to create a MySQL Server in Azure<https://scribehow.com/shared/Creating_MySQL_Server_in_Azure__Nrr4hJ39T7e1RSr347o_RA>
1
Sign in into the **Microsoft Azure Portal**
2
Type **Azure Database for MySQL server** in the search bar and click on the **Azure Database for MySQL server**
information ordinal icon
**What is Azure Database for MySQL server ?**\ \ Azure Database for MySQL server is a fully managed database service that offers scalable, secure, and high-performance MySQL database management with built-in features like automated backups, patching, and monitoring.
3
On the **Azure Database for MySQL servers** wizard, click on the Name **mysqldtabasein28min**
4
Click on the **Networking** from the left bar to configure Networking details
5
Scroll to the **Firewall rules** section and tick the checkbox **Note:** This will allow public access from any Azure service within to this server
6
Click on the **Add current client IP address** link **Note:** This will add your current IP address to the firewall rule, allowing only this IP to access the MySQL server.
7
Click on the **Save** button on the top left side to update the changes
information ordinal icon
Congratulations on successfully configuring the networking for the MySQL server!
8
To connect to your MySQL Server, click on the **Connect** from the left bar
9
Scroll to the **Connect from browser or locally** section and click on the copy widget to copy the command
10
To connect the MySQL via Azure Cloud shell, click on the **Azure Cloud shell** widget on the top right side
information ordinal icon
**What is Azure Cloud Shell?**\ \ Azure Cloud Shell is an interactive, browser-based shell that provides command-line access to Azure resources. It includes tools for managing Azure resources using either Bash or PowerShell, enabling easy administration and automation directly from the Azure portal.
11
**Azure Cloud Shell** wizard will open, wait for the Cloud shell to get connect successfully
12
On the **Azure Cloud shell** wizard, paste the copied command and enter the password for the MySQL Server **Note:** This password is the one you created when setting up the MySQL server in Azure
13
**You are successfully connected to your MySQL Server**
information ordinal icon
Congratulations on successfully connecting to the MySQL server using Azure Cloud Shell!
14
To create a database named "**todos**" in the MySQL, type the command "**create database todos;**"
information ordinal icon
**What is a "create database todos;" query?**\ \ The query `CREATE DATABASE todos;` is an SQL command used to create a new database named "todos" in a MySQL database management system.