Manage an Azure Database for MySQL server using the Azure portal

APPLIES TO: Azure Database for MySQL - Single Server

Important

Azure Database for MySQL single server is on the retirement path. We strongly recommend that you upgrade to Azure Database for MySQL flexible server. For more information about migrating to Azure Database for MySQL flexible server, see What's happening 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.

   

   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.

   

   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.

   

   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.

   

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

   

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.

   

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

   

   Note

   Deleting a server is irreversible.

3. Select Delete.

Next steps

• Learn about backups and server restore
• Learn about tuning and monitoring options in Azure Database for MySQL