Manage an Azure Database for MySQL server using the Azure portal

APPLIES TO: Azure Database for MySQL - Single Server

This article shows you how to manage your Azure Database for MySQL servers. Management tasks include compute and storage scaling, admin password reset, and viewing server details.

Note

This article contains references to the term slave, a term that Microsoft no longer uses. When the term is removed from the software, we'll remove it from this article.

Sign in

Sign in to the Azure portal.

Create a server

Visit the quickstart to learn how to create and get started with an Azure Database for MySQL server.

Scale compute and storage

After server creation you can scale between the General Purpose and Memory Optimized tiers as your needs change. You can also scale compute and memory by increasing or decreasing vCores. Storage can be scaled up (however, you cannot scale storage down).

Scale between General Purpose and Memory Optimized tiers

You can scale from General Purpose to Memory Optimized and vice-versa. Changing to and from the Basic tier after server creation is not supported.

  1. Select your server in the Azure portal. Select Pricing tier, located in the Settings section.

  2. Select General Purpose or Memory Optimized, depending on what you are scaling to.

    Screenshot of Azure portal to choose Basic, General Purpose, or Memory Optimized tier in Azure Database for MySQL

    Note

    Changing tiers causes a server restart.

  3. Select OK to save changes.

Scale vCores up or down

  1. Select your server in the Azure portal. Select Pricing tier, located in the Settings section.

  2. Change the vCore setting by moving the slider to your desired value.

    Screenshot of Azure portal to choose vCore option in Azure Database for MySQL

    Note

    Scaling vCores causes a server restart.

  3. Select OK to save changes.

Scale storage up

  1. Select your server in the Azure portal. Select Pricing tier, located in the Settings section.

  2. Change the Storage setting by moving the slider up to your desired value.

    Screenshot of Azure portal to choose Storage scale in Azure Database for MySQL

    Note

    Storage cannot be scaled down.

  3. Select OK to save changes.

Update admin password

You can change the administrator role's password using the Azure portal.

  1. Select your server in the Azure portal. In the Overview window select Reset password.

    Screenshot of Azure portal to reset the password in Azure Database for MySQL

  2. Enter a new password and confirm the password. The textbox will prompt you about password complexity requirements.

    Screenshot of Azure portal to reset your password and save in Azure Database for MySQL

  3. Select OK to save the new password.

Important

Resetting server admin password will automatically reset the server admin privileges to default. Consider resetting your server admin password if you accidentally revoked one or more of the server admin privileges.

Note

Server admin user has the following privileges by default: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER

Delete a server

You can delete your server if you no longer need it.

  1. Select your server in the Azure portal. In the Overview window select Delete.

    Screenshot of Azure portal to Delete the server in Azure Database for MySQL

  2. Type the name of the server into the input box to confirm that this is the server you want to delete.

    Screenshot of Azure portal to confirm the server delete in Azure Database for MySQL

    Note

    Deleting a server is irreversible.

  3. Select Delete.

Next steps