Access denied on phpMyAdmin for Azure wordpress app whit in App mySQL

Question

Hi
I want to migrate my WordPress azure app to a new server. to do this I have to download all pages and export the database.
This is a first WordPress for my customer I have created a word press with an in app mySQL database.
If I try the manage Option in the Azure portal

I get

How can I fix this.

Answer 1

@Michiel van Buuren Thanks for reaching out. From the screenshot above, it seems like you're running into a mysql socket error. This usually happens when you restart the web app, and try to access the phpMyAdmin interface directly without accessing the website.

The simplest way to resolve the issue would be to first access your web app from your browser at: https://<appname>.azurewebsites.net/ and then browse to phpAdmin interface at: https://<appname>.scm.azurewebsites.net/phpMyAdmin/

If that does not help, you may want to verify the following:

• Check whether the MySQL process is actually running or not from: {Your app} > Tools > Process Explorer, or
• Verify that you do not have two instances of phpMyAdmin installed: With MySQL in-app phpMyAdmin is already preconfigured and setup. If you install phpMyAdmin from Site extensions gallery again, then you will end up having two instances of phpMyAdmin. To resolve this, you'll need to remove the site extension, restart your web app and then access your DB using the phpMyAdmin interface.

If you still encounter issues, please follow the guidelines detailed in this troubleshooting guide: Troubleshooting FAQ for MySQL in-app

Hope this helps. Do let us know if you have further questions.

----------

If an answer is helpful, please "Accept answer" and/or "Up-Vote" which might help other community members reading this thread.