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.

3
Leave a Reply

avatar
2 Comment threads
1 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
2 Comment authors
AndrewMazhar Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
Mazhar
Guest

Hi Andrew,

You suggestion helped me a lot but one thing I want to know is that, Is there any way to know previous password ? Is there any way to get back previous password only ?