This post is particularly directed at a configuration of an Azure wordpress website with MySql as a linked resource.
Select your Azure wordpress website in your Azure portal then select dashboard
If you scroll to the bottom you will see a section titled ‘linked resources’ under here you should see your MySql database linked resource.
If you click on your MySql database name it will bring you to a clear db web portal.
If you click endpoint information from the top menu, note down your hostname along with your access credentials as you will need them to log in to a MySql client (MySql workbench)
Next click on the dashboard menu item on the clear db web portal and under the ‘Managing Your Database’ heading you should see a MySql workbench link which will bring you to a download page in which you can go and follow the instructions to download and install the client.
Once the client has been installed you should be able to run it and enter the hostname, username and password for your MySql database you noted earlier in the prompt that appears .
From here you should see a query windows open by default if you type in ‘SELECT * FROM [your database name].wp_users;’ and select the lightning bolt in the menu that will execute this sql statement you should see a list of users in your wp_users table in your database.
From here you can manually edit the ‘user_pass’ column that is associated with the admin account with an md5 hash(you will need to generate an MD5 hash of your new password, which you can utilize md5 hash online generators) of your newly chosen password and select the apply bottom near the bottom right of the table view.
That’s it – you can now go to back to your login page and enter your username with the new password and login.