How do I access my PHPMyAdmin Account and my SQL database on my Azure App Service portal?

Question

How do I access my PHPMyAdmin Account and my SQL database on my Azure App Service portal?

KM 0

I have created my WordPress site on Azure App Service on Linux with a Flexible MySQL Azure Database by following the Microsoft document at https://learn.microsoft.com/en-us/azure/app-service/quickstart-wordpress?wt.md_id=searchAPI_azureportal_inproduct_rmskilling&sessionId=19219dd720cc4cbf970791f07139bdf4. To migrate my existing WordPress site to the Azure instance, I used the all-in-one plugin. However, when I tried to access my PHPMyAdmin account and find my SQL database on the Azure App Service Portal, I faced multiple issues.

I referred to https://azure.github.io/AppService/2016/09/08/Troubleshooting-FAQ-for-MySQL-in-app.html but the "MySQL-in-app" and "Process Explorer" buttons are not on my portal.

When I tried to access "<mywebsitename.azurewebsites.net>/phpymyadmin," it showed a login form asking for the database username and password from my app configuration settings. However, it gave me a "403 - You don't have authorization to view this page" error after submitting the credentials.

I also tried accessing "<mywebsitename>.scm.azurewebsites.net/phpmyadmin", but it returned a "No route registered for '/phpmyadmin'" error.

Can anyone help me resolve this issue and access my PHPMyAdmin account and SQL database on the Azure App Service Portal? Thank you in advance for your assistance!

brtrach-MSFT 17,731 Reputation points Microsoft Employee Moderator

2023-08-04T02:54:17.1933333+00:00

@KM Please let us know if the below answer from yesterday is helpful by accepting it as the answer. If you have further questions or concerns, please reply here so we can assist you further.

2 answers

Your answer

brtrach-MSFT 17,731 Reputation points Microsoft Employee Moderator

2023-08-04T02:54:17.1933333+00:00

@KM Please let us know if the below answer from yesterday is helpful by accepting it as the answer. If you have further questions or concerns, please reply here so we can assist you further.

Answer 1

Vahid Ghafarpour 23,385 Volunteer Moderator

The "MySQL-in-app" feature is only available for Windows-based Azure App Service plans. This feature won't be available since you are using a Linux-based Azure App Service. Instead, you need to use a separate MySQL database, which you have already set up as a Flexible MySQL Azure Database.

It would be best if you started PHPMyAdmin. Would you please try this command:

phpmyadmin --host=localhost --user=<your-database-username> --password=<your-database-password>

KM 0 Reputation points

2023-07-21T18:33:58.06+00:00

Hi! I appreciate your answer. Sorry, but where are you wanting me to try this command?
Vahid Ghafarpour 23,385 Reputation points Volunteer Moderator

2023-07-21T18:48:26.4533333+00:00

In Kudu, you can use the "Debug Console" to access the command prompt or use the "SSH" option to access a secure shell. From there, you can run commands directly in the terminal.

It's possible that PHPMyAdmin is not deployed or configured correctly. Double-check your deployment process and ensure PHPMyAdmin is configured to work with your MySQL Azure Database.
KM 0 Reputation points

2023-07-21T18:53:37.2833333+00:00

Due to it being a linux container, the kudu looks pretty different from how I've seen it from others. Mine does not have a category called "Debug Console", but I did attempt to put the command you gave in the SSH and the Bash consoles on my Kudu. They both gave the error, "phpmyadmin: command not found".

I used the marketplace item that was recommended in the documentation. It states it sets up the db and connects it to phpmyadmin. In my app config settings it does have, "SETUP_PHPMYADMIN" set to true.
KM 0 Reputation points

2023-07-26T12:48:36.2533333+00:00

Hi, this might be a dumb question but could my issue, "403 - You don't have authorization to view this page" be caused by the vnet integration configuration. I was thinking it could be a firewall or networking setting that is causing the issue, and that is the only setting that is currently on, but when I click on the vnet integration page, the values for the page (ex: vnet name, location, address space) are infinitely loading, so I can't tell if it could be the cause.

Answer 2

@KM To expand upon the great answers by Vahid, you can try running the command I provided in the Bash console in Kudu. If it says "phpmyadmin: command not found", it's possible that PHPMyAdmin is not installed on your Azure App Service.

Regarding the "403 - You don't have authorization to view this page" error, it's possible that it's caused by a firewall or networking setting. However, it's also possible that it's caused by incorrect credentials. Please double-check that you're using the correct database username and password in the login form.

If you're still having trouble accessing PHPMyAdmin, you can try redeploying your app and ensuring that PHPMyAdmin is properly configured to work with your MySQL Azure Database. If the issue persists, please let me know and we can explore other solutions.

Share via

How do I access my PHPMyAdmin Account and my SQL database on my Azure App Service portal?

2 answers

Your answer