Playing with MySQL Server in Azure | Scribe

    Playing with MySQL Server in Azure

    • Hafeez Baig |
    • 22 steps |
    • 2 minutes
    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.