Use an Azure free account to try Azure Database for MySQL - Flexible Server for free

Azure Database for MySQL - Flexible Server is a managed service that you use to run, manage, and scale highly available MySQL databases in the cloud. With an Azure free account, you can use Flexible Server for free for 12 months with monthly limits of up to:

  • 750 hours of Burstable B1MS instance, enough hours to run a database instance continuously each month.
  • 32 GB storage and 32 GB backup storage.

This article shows you how to create and use a flexible server for free using an Azure free account.

Prerequisites

To complete this tutorial, you need:

Create an Azure Database for MySQL - Flexible Server

In this article, you'll use the Azure portal to create a Flexible Server with public access connectivity method. Alternatively, refer the respective quickstarts to create a Flexible Server using Azure CLI or ARM template, or within a VNET.

  1. Sign in to the Azure portal with your Azure free account.

    The default view is your service dashboard.

  2. To create a MySQL Flexible Server database, search for and select Azure Database for MySQL servers:

    Screenshot that shows how to search and select Azure Database for MySQL on Azure portal.

    Alternatively, you can search for and navigate to Free Services, and then select Azure Database for MySQL tile from the list:

    Screenshot that shows a list of all free services on the Azure portal.

  3. Select Create.

  4. On the Select Azure Database for MySQL deployment option page, select Flexible Server.

    Screenshot that shows the Flexible Server Deployment Option to be chosen.

  5. Enter the basic settings for a new Flexible Server.

    Screenshot that shows the Basic Settings for creating Flexible Server.

    Setting Suggested value Description
    Subscription Your subscription Select the Free Trial Azure subscription.
    Resource group Your resource group Enter a new resource group or an existing one from your subscription.
    Server name mydemoserver-mysql Specify a unique name to identify your flexible server. The domain name mysql.database.azure.com is appended to the server name you provide. The server name can contain only lowercase letters, numbers, and the hyphen (-) character. It must contain between 3 and 63 characters.
    Region The region closest to your users Select a location from the list, preferably the location that's closest to your users.
    Workload type Development For a free trial, select Development workload. For a production workload, choose Small/Medium-size or Large-size depending on max_connections requirements.
    Availability zone No preference If your application (hosted on Azure VMs, virtual machine scale sets or AKS instance) is provisioned in a specific availability zone, create your flexible server in the same availability zone. Collocating the application and database improves performance by reducing network latency across zones.
    High Availability Default Leave the High Availability option unchecked.
    MySQL version The latest major version Use the latest major version. For more information, see all supported versions.
    Admin username myadmin Create a sign-in account to use when you connect to the server. The admin username can't be azure_superuser, admin, administrator, root, guest, or public.
    Password Your password Specify a new password for the server admin account. The password must contain between 8 and 128 characters. It must also contain characters from three of the following four categories: English uppercase letters, English lowercase letters, numbers (0 through 9), and non-alphanumeric characters (!, $, #, %, and so on).
  6. For Compute + Storage setting, select Configure Server.

    Select Burstable B1MS Instance (1-2 vCores), specify storage less than or equal to 32 GB and keep the default settings for the remaining options.

    Screenshot that shows the Compute + Storage Configure Server blade, to choose B1MS SKU and 32GB Storage.

  7. Select Save to continue with the configuration.

  8. Select Networking tab to configure how to reach your server.

    Azure Database for MySQL - Flexible Server provides two ways to connect:

    • Public access (allowed IP addresses)
    • Private access (VNet Integration)

    With public access, access to your server is limited to allowed IP addresses that you include in a firewall rule. This method prevents external applications and tools from connecting to the server and any databases on the server, unless you create a rule to open the firewall for a specific IP address or range.

    With private access (VNet Integration), access to your server is limited to your virtual network. For more information about connectivity methods, see Connectivity and networking concepts.

    For the purposes of this tutorial, enable public access to connect to the server.

  9. On the Networking tab, for Connectivity method select Public access.

  10. For configuring Firewall rules, select Add current client IP address.

    Screenshot that shows the networking options to be chosen, and highlights the add current client IP address button.

    Note

    You can't change the connectivity method after you create the server. For example, if you select Public access (allowed IP addresses) during server creation, you can't change to Private access (VNet Integration) after the server is created. We highly recommend that you create your server with private access to help secure access to your server via VNet Integration. For more information about private access, see Connectivity and networking concepts.

  11. To review your flexible server configuration, select Review + create.

    Screenshot that shows the Review + create blade.

    Important

    While creating the Flexible server instance from your Azure free account, you will still see an Estimated cost per month in the Compute + Storage : Cost Summary blade and Review + Create tab. But, as long as you are using your Azure free account, and your free service usage is within monthly limits (to view usage information, refer Monitor and track free services usage section below), you won't be charged for the service. We're currently working to improve the Cost Summary experience for free services.

  12. Select Create to provision the server.

    Provisioning can take a few minutes

  13. On the toolbar, select Notifications (the bell icon) to monitor the deployment process.

    After the deployment is complete, select Pin to dashboard, to create a tile for the flexible server on your Azure portal dashboard. This tile is a shortcut to the server's Overview page. When you select Go to resource, the server's Overview page opens.

    By default, your server included these databases: information_schema, mysql, performance_schema, and sys.

Connect and query

Now that you've now created an Azure Database for MySQL - Flexible Server in a resource group, you can connect to server and query databases by using the following Connect and query quickstarts:

Monitor and track free services usage

You're not charged for Azure Database for MySQL - Flexible Server services included for free with your Azure free account unless you exceed the free service limits. To remain within the limits, use the Azure portal to track and monitor your free services usage.

  1. In the Azure portal, search for Subscriptions and select the Azure Free Account - Free Trial subscription.

  2. On the Overview page, scroll down to show the tile Top free services by usage, and then select View all free services.

    Screenshot that shows the Free Trial subscription overview page and highlights View all free services.

  3. Locate the meters related to Azure Database for MySQL – Flexible Server to track usage.

    Screenshot that shows the View and track usage information blade on Azure Portal for all free services.

    Meter Description Monthly Limit
    Azure Database for MySQL, Flexible Server Burstable BS Series Compute, B1MS Tracks Compute usage in terms of number of hours of running 750 Hours per month - Burstable B1MS Compute Tier
    Azure Database for MySQL, Flexible Server Storage, Data Stored Tracks Data Storage Provisioned in terms of GiB used per month 32 GB per month
    • Meter: Identifies the unit of measure for the service being consumed.
    • Usage/Limit: Current month's usage and limit for the meter.
    • Status: Usage status of the service. Based on your usage, you can have one of the following statutes:
    • Not in use: You haven't used the meter or the usage for the meter hasn't reached the billing system.
    • Exceeded on <Date>: You've exceeded the limit for the meter on <Date>.
    • Unlikely to Exceed: You're unlikely to exceed the limit for the meter.
    • Exceeds on <Date>: You're likely to exceed the limit for the meter on <Date>.

    Important

    With an Azure free account, you also get $200 in credit to use in 30 days. During this time, any usage beyond the free monthly amounts of services will be deducted from this credit. At the end of your first 30 days or after you spend your $200 credit (whichever comes first), you'll only pay for what you use beyond the free monthly amounts of services. To keep getting free services after 30 days, move to pay-as-you-go pricing. If you don't move to pay as you go, you can't purchase Azure services beyond your $200 credit—and eventually your account and services will be disabled. For more information, see Azure free account FAQ.

Clean up resources

If you are using the flexible server for development, testing or predictable time-bound production workloads, optimize usage by starting and stopping the server on-demand. After you stop the server, it remains in that state for seven days unless restarted sooner. For more information, see Server concepts. When your Flexible Server is stopped, there is no Compute usage, but Storage usage is still considered.

Alternatively, if you don't expect to need these resources in the future, you can delete them by deleting the resource group, or you can just delete the MySQL server.

  • To delete the resource group, complete the following steps:

    1. In the Azure portal, search for and select Resource groups.
    2. In the list of resource groups, select the name of your resource group.
    3. On the Overview page for your resource group, select Delete resource group.
    4. In the confirmation dialog box, type the name of your resource group, and then select Delete.
  • To delete the MySQL server, on Overview page for the server, select Delete.

Next steps