Quickstart: Create an Azure Database for MySQL server in the Azure portal
Azure Database for MySQL is a managed service that you use to run, manage, and scale highly available MySQL Databases in the cloud. This Quickstart shows you how to create an Azure Database for MySQL server in about five minutes using the Azure portal.
If you don't have an Azure subscription, create a free Azure account before you begin.
Sign in to the Azure portal
Open your web browser, and then go to the Azure portal. Enter your credentials to sign in to the portal. The default view is your service dashboard.
Create an Azure Database for MySQL server
Follow these steps to create an Azure Database for MySQL server:
Select Create a resource (+) in the upper-left corner of the portal.
Select Databases > Azure Database for MySQL. You can also enter MySQL in the search box to find the service.
- Fill out the new server details form with the following information:
|Setting||Suggested value||Field description|
|Subscription||Your subscription||Select the Azure subscription that you want to use for your server. If you have multiple subscriptions, choose the subscription in which you get billed for the resource.|
|Resource group||myresourcegroup||Provide a new or existing resource group name. Resource group can be used organize your dependencies that belong to single project.|
|Server name||Unique server name||Enter a unique name that identifies your Azure Database for MySQL server. For example, 'mysqldbserver'.The server name can contain only lowercase letters, numbers, and the hyphen (-) character. It must contain from 3 to 63 characters.|
|Data source||None||Select None to create a new server from scratch. (You would select Backup if you were creating a server from a geo-backup of an existing Azure Database for MySQL server).|
|Server admin login||myadmin||Enter a username for your server administrator. You cannot use azure_superuser, admin, administrator, root, guest, or public as the admin username.|
|Password||Your choice||Provide a new password for the server admin account. Password must be 8 to 128 characters in length with a combination of uppercase or lowercase letters, numbers, and non-alphanumeric characters (!, $, #, %, and so on).|
|Confirm password||Your choice||Confirm the admin account password.|
|Location||The region closest to your users||Choose the location that is closest to your users or your other Azure applications.|
|Version||The latest major version||The latest major version (unless you have specific requirements that require another version).|
|Compute + Storage||General Purpose, Gen 5, 2 vCores, 5 GB, 7 days, Geographically Redundant||The compute, storage, and backup configurations for your new server. Select Configure server. Next, select the appropriate pricing tier, for more information, see the pricing page. To enable your server backups in geo-redundant storage, select Geographically Redundant from the Backup Redundancy Options. Select OK.|
Consider using the Basic pricing tier if light compute and I/O are adequate for your workload. Note that servers created in the Basic pricing tier cannot later be scaled to General Purpose or Memory Optimized.
Select Review + create to provision the server. Provisioning can take up to 20 minutes.
Select Notifications on the toolbar (the bell icon) to monitor the deployment process.
By default, the following databases are created under your server: information_schema, mysql, performance_schema, and sys.
Configure a server-level firewall rule
By default the server created is protected with a firewall and is not accessible publicly. To give access to your IP, go to your server resource in the Azure portal and select Connection security from left-side menu for your server resource. Don't know how to find your resource, see How to open a resource.
Now select Add current client IP address and then select Save. You can add additional IPs or provide an IP range to connect to your server from those IPs. For more information, see How to manage firewall rules on Azure Database for MySQL server
Check if your network allows outbound traffic over port 3306 that is used by Azure Database for MySQL to avoid connectivity issues.
Connect to Azure Database for MySQL server using mysql command-line client
Launch Azure Cloud Shell in the portal by clicking the highlighted icon on the top-left side. Make a note of your server name, server admin login name, password, and subscription for your newly created server from the Overview section as shown in the image below.
If you are launching cloud shell for the first time, you will see a prompt to create a resource group, storage account. This is a one- time step and will be automatically attached for all sessions.
Run this command on Azure Cloud Shell terminal. Replace values with your actual server name and admin user login name. The admin username requires '@<servername>' as shown below for Azure Database for MySQL
mysql --host=mydemoserver.mysql.database.azure.com --user=myadmin@mydemoserver -p
Here is how the experience looks like in the Cloud Shell terminal
Requesting a Cloud Shell.Succeeded. Connecting terminal... Welcome to Azure Cloud Shell Type "az" to use Azure CLI Type "help" to learn about Cloud Shell user@Azure:~$mysql -h mydemoserver.mysql.database.azure.com -u myadmin@mydemoserver -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 64796 Server version: 126.96.36.199 Source distribution Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
- In the same Azure Cloud Shell terminal, create a database guest
mysql> CREATE DATABASE guest; Query OK, 1 row affected (0.27 sec)
- Change to database guest
mysql> USE guest; Database changed
quit, and then select the Enter key to quit mysql.
Clean up resources
You have successfully created an Azure Database for MySQL server in a resource group. If you don't expect to need these resources in the future, you can delete them by deleting the resource group or just delete the MySQL server. To delete the resource group, follow these steps:
- In the Azure portal, search for and select Resource groups.
- In the resource group list, choose the name of your resource group.
- In the Overview page of your resource group, select Delete resource group.
- In the confirmation dialog box, type the name of your resource group, and then select Delete.
To delete the server, you can click on Delete button on Overview page of your server as shown below: