How to use PHPMyadmin for your Azure Web App

Azure Web Apps provides an array of tools through the Site extension Gallery. One such tool is PHPMyadmin which allows you to access your database. Once you log on to the Azure Management portal, browse to your web app and view the application settings to link your MySQL database with your web app.

Add a connection string under Web App Settings as shown below.

phpmyadmin1

Now you can install PHPMyAdmin site extension onto your web app. Click on Extensions->Add  to view all the available extensions.

phpmyadmin2

Select PHPMyAdmin from the list of available extensions

phpmyadmin3

 

Accept the legal term and click OK

phpmyadmin4

After a few minutes , you have PHP Myadmin site extension enabled.Now you can access phpmyadmin , using this URL https://<sitename>.scm.azurewebsites.net/phpmyadmin/ ( replace <sitename> with you web app name in the URL ) 

phpmyadmin6

 

 

Advertisements

5 thoughts on “How to use PHPMyadmin for your Azure Web App

  1. Hi, I have problem in creating User with full privileges in PHPMyAdmin

    How can I give privileges to an existing user for a certain database Or new one?

    When I try to create a new user in a newly created database, It gives following error

    #1044 – Access denied for user ‘azure’@’localhost’ to database ‘sdt678u’

    I’m using following template
    https://azuremarketplace.microsoft.com/en-us/marketplace/apps/Microsoft.WebSiteMySQLDatabase

    Any help will be appreciated a lot.

    1. This is not supported since MySQL in-app or ClearDB MySQL solution dont give you complete access to the MySQL server. You get one database and one user with full privileges on that database

  2. I followed all the steps but I end up getting “Cannot connect: invalid settings” “phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.” What am I missing?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s