connect phpmyadmin to web app + database

Question

Mamadou Oury BARRY 50

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

SSingh-MSFT 16,461 Reputation points Moderator

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,597 Reputation points Microsoft Employee Moderator

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,597 Reputation points Microsoft Employee Moderator

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

SSingh-MSFT 16,461 Reputation points Moderator

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,597 Reputation points Microsoft Employee Moderator

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,597 Reputation points Microsoft Employee Moderator

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

Answer 1

GeethaThatipatri-MSFT 29,597 Microsoft Employee Moderator

@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

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.

Answer 2

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.

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