Read all of the other posts in our series on Creating Azure (hosted) WordPress Websites without knowing php or MySql!
To work directly on the MySql database associated with your Azure hosted WordPress website, you need to load the phpMyadmin website extension via the Kudu UI or the Azure Portal. but
We don’t work with MySql, but having direct access to the MySQL database is helpful if your admin login became corrupted and you were unable to connect to the website! In the phpMyadmin interface, it is a quick fix to add a new admin user to the database and then login to the website again. Lockout averted!
This is a good step-by-step article on How to Add an Admin User to the WordPress Database via MySQL
From the Azure Portal for the website: Development Tools > Extensions > Add > Choose phpMyadmin from the list of extensions > OK
When the extension is successfully loaded, browse to the phpMyadmin console to access the website’s MySql database.
URL will be https://<sitename>.scm.azurewebsites.net/phpmyadmin/
It is also a best practice to first backup the website’s database via Azure Web App Backup Service and Website Content before making any changes to the database, just in case!
Read all of the other posts in our series on Creating Azure (hosted) WordPress Websites without knowing php or MySql!