How to Reset Password for Azure Database

Microsoft Azure's Azure Database provides cloud-based database solutions for all types of data management requirements. Users don't need to worry about infrastructure upkeep while creating, scaling, and managing databases thanks to alternatives like SQL databases and Azure Database for MySQL. This post offers details on how to create and manage databases in Azure, as well as an overview of its capabilities and advantages.

Steps to reset Password for Azure Database using Azure Portal

First, we need to create a database in Azure.

Step 1: Navigate to your Azure Portal.

Step 2: Go to the Database for which you want to change the Password. Here, I want to change the password for my database, Azure Database for MySQL flexible Server, that I created earlier.

Step 3: In the right-hand menu, click on the Overview blade.

Step 4: Click on Reset Password button.

Step 5: In the pop-up menu, enter the New Password. Then re-enter the same password to confirm it.

The password you create has to follow the following rules:

• A minimum of 8 characters and a maximum of 128 characters are required in your password.
• Three different character sets must be included in your password: English capital, English lowercase, numerals (0–9), and non-alphanumeric characters (!, $, #, %, etc.).
• The login name cannot appear in whole or in part in your password. Three or more consecutive alphanumeric characters are considered to be a part of a login name.

Step 6: Click on Save.

• You will see the following notification saying Resetting the Password.
• After sometime, you will get the notification saying Successfully reset the password.

Steps to reset Password for Azure Database using Azure CLI

Here are the detail steps to reset Password for Azure Database using Azure CLI (command line interface)

Step 1: Click on the Cloud Shell icon present on the immediate right of search bar.

Step 2: You will be prompted to choose a storage account. Create a new one if no storage account has already been created. You will see the following after that.

Step 3: Login to Azure using the command:

az login

You will be prompted to go to the link https://www.microsoft.com/devicelogin. Follow the link and enter the code provided in the cloud shell in order to authenticate.

After successful authentication, you will see the following output.

Step 4: To reset password, enter the following command:

Note: Command may vary slightly for different resource types.

az mysql flexible-server update 
--resource-group <resource-group-name>
--name <name> 
--admin-password <enter-new-password>

Replace the <resource-group-name> with the Resource Group Name in which you have created the database, replace <server-name> with name of the server. Finally, enter the New Password.

After successful execution of the command, you may see the output such as: