Creating MySQL Server in Azure | Scribe

Creating MySQL Server in Azure

  • Hafeez Baig |
  • 16 steps |
  • 2 minutes
  • AzureAzure
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 **Quick 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
Scroll to the **Workload type** section and click on the **Dev/Test** option
6
**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.
7
**Resource group** wizard will open, give Name as "**databases-rg**" and click on the **OK** button
8
Scroll to the **Server name** section and give the Name as "**mysqldatabasein28**"
9
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.
10
Scroll to the **Admin username** section and give the username as "**mysqldatabasein28**"
11
Give the password in the **Password** input field and click on the **Review + create** button
12
**Review** wizard will open, review all the configurations
13
On the right side you can view the **Estimated costs** wizard
14
Scroll the page and click on the **Create** button
15
**Configure IP address in firewall rules** section and click on the **Create server without firewall rules** button
16
**Your deployment is complete**