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

Michiel van Buuren 21 Reputation points
2021-06-29T11:33:45.387+00:00

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
110238-memo-lab-protal.png
I get
110207-myphpadmin-error.png
How can I fix this.

Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,833 questions
0 comments No comments
{count} votes

Accepted answer
  1. BhargaviAnnadevara-MSFT 5,446 Reputation points
    2021-07-02T15:12:08.42+00:00

    @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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful