connect phpmyadmin to web app + database

Mamadou Oury BARRY 50

Hello, please how could I connect phpmyadmin in the webapp?

ShaktiSingh-MSFT 15,301 Reputation points

2023-04-04T05:41:46.54+00:00

Hi Mamadou Oury BARRY •, Could you please share the steps you have followed to connect php to Azure MySQL database and at which step you are stuck? Screenshots would be helpful. Looking forward to your reply.
Mamadou Oury BARRY 50 Reputation points

2023-04-04T19:35:02.73+00:00

I create it with WebApp + Database, the deployment with the WebApp is working, but not for the database, i want connect phpmyadmin to the database. i dont know how i can do. there is the screenshot the webapp and database.
GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2023-04-04T21:50:25.1333333+00:00

@Mamadou Oury BARRY Have you tried the code which is in the document and followed the prerequisites? https://learn.microsoft.com/en-us/azure/mysql/single-server/connect-php#prerequisites
Mamadou Oury BARRY 50 Reputation points

2023-04-06T04:03:29.8633333+00:00

Thank you. i try but something is wrong with the host. when i copy the name of server in side the file config.inc.php. after finish to add my credential in the file. i get this error. The configuration file contains an invalid authentication type mydatabasnameserver-server.mysql.database.azure.com
GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2023-04-06T20:45:48.6933333+00:00

@Mamadou Oury BARRY Can you please share code snippet? might be related to the wrong password. Regards Geetha

2 answers

Syed Shiraz Shahid 280 Reputation points

2023-04-03T21:46:25.71+00:00
To connect phpMyAdmin to your Azure Web App and MySQL database, follow these steps:

Deploy phpMyAdmin to your Azure Web App by creating a new Web App or updating an existing one. You can find instructions on how to deploy a Web App in the Azure Portal documentation.

Configure your Azure MySQL database for remote access by adding your Web App's IP address to the server's firewall rules. You can find instructions on how to do this in the Azure Portal documentation.

Open phpMyAdmin in your web browser by navigating to your Web App's URL followed by "/phpmyadmin". For example, if your Web App's URL is "mywebapp.azurewebsites.net", you would navigate to "mywebapp.azurewebsites.net/phpmyadmin".

Log in to phpMyAdmin using the credentials for your MySQL database. You can find these credentials in the Azure Portal under the "Connection strings" section of your MySQL database resource.

Once you are logged in to phpMyAdmin, you should be able to view and manage your MySQL database.
Please sign in to rate this answer.
Mamadou Oury BARRY 50 Reputation points

2023-04-04T03:12:51.4033333+00:00

Hello Shahid thank you, i try what you are explain me with my webapp link /phpmyadmin but is not goin the showin 404 Error
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2023-04-03T22:07:20.96+00:00

@Mamadou Oury BARRY Welcome to the Microsoft Q&A forum, Thanks for posting your question.

If I understand correctly you want to know how to connect Azyre Mysql Database using PHP

You can find a quickstart guide on how to connect to Azure Database for MySQL using PHP

https://learn.microsoft.com/en-us/azure/mysql/single-server/connect-php Please let me know if you find any issues or need any additional information.

Regards Geetha
Please sign in to rate this answer.
Mamadou Oury BARRY 50 Reputation points

2023-04-04T03:16:44.63+00:00

Thank you GeethaThatipatri-MSFT but with this link you are givin me i don't understand good, i think is height for me. i just want config my database with phpmyadmin and deployin my db.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

connect phpmyadmin to web app + database

2 answers

Your answer