Creating MySQL Server in Azure | Scribe

    Creating MySQL Server in Azure

    • Hafeez Baig |
    • 15 steps |
    • 46 seconds
    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

    **Azure Database for MySQL server** wizard will open, click on the **Create** button on the left side

    4

    **Select Azure Database for MySQL deployment** wizard will open, Select the **Flexible server** option and click on the **Create** button

    information ordinal icon

    **What is Flexible Server?**\ \ Flexible Server in Azure Database for MySQL is a deployment option that provides more control and flexibility over database management, including server configuration, maintenance windows, and high availability options.\ \ **What is Wordpress + MySQL Fexible Server?**\ \ WordPress + MySQL Flexible Server is a pre-configured setup in Azure that deploys WordPress with a MySQL Flexible Server backend, offering a scalable and managed environment for hosting WordPress websites.

    5

    **Flexible server** wizard will open, scroll to the **Resource group** section and click on the **Create new** link

    information ordinal icon

    **What is Resource group?**\ \ Resource Group is a container that holds related resources for an Azure solution, enabling you to manage and organize them as a single entity based on their lifecycle and permissions.

    6

    **Resource group** wizard will open, give Name as "**databases-rg**" and click on the **OK** button

    7

    Scroll to the **Server name** section and give the Name as "**mysqldatabasein28**"

    8

    Scroll to the **Authentication method** section section and select the **MySQL authentication only** option

    information ordinal icon

    **What is MySQL authentication only option?**\ \ The MySQL authentication only option in Azure Database for MySQL restricts authentication to MySQL's native user authentication, enhancing compatibility and simplifying user management by using only MySQL credentials for database access.

    9

    Scroll to the **Admin username** section and give the username as "**mysqldatabasein28**"

    10

    Give the password in the **Password** input field and click on the **Review + create** button

    11

    **Review** wizard will open, review all the configurations

    12

    On the right side you can view the **Estimated costs** wizard

    13

    Scroll the page and click on the **Create** button

    14

    **Configure IP address in firewall rules** section and click on the **Create server without firewall rules** button

    15

    **Your deployment is complete**

    information ordinal icon

    Congratulations on completing this lab and Creating MySQL Server in Azure! Good Job!