Installing PHPMyAdmin for Azure WebApp using Site Control Manager (Kudu)

This tutorial shows you how to setup a PHPMyAdmin site in an Azure WebApp using Site Control Manager (KUDU Console)

When you are done with this tutorial, you’ll have a PHPMyAdmin site setup along with your Azure WebApp and connected with your MySql deployment (ClearDB as well as VM based MySQL).

Most PHP Developers are accustomed to use PHPMyAdmin tool to manage their MySQL workloads, for reasons like A-it comes in very handy and you can practically do everything related to your mysql databases right from within this web based console.

PHPMyAdmin can be downloaded from http://phpmyadmin.net/ , but soon as the developers start working with the Azure WebApps they get confused as to if they should install their web app code or the phpmyadmin, or should phpmyadmin be a separate website altogether?

Well !Azure has an answer — and that is — PHPMyAdmin is an extension and the extensions can live separate from your website code, and for installing an extension as mundane as PHPMyAdmin you don’t need to download or upload anything because Azure understands that its quite a very genuine thing to ask for when you are running a PHP + MySQL workload.

Setting up PHPMyAdmin extension using SCM (Kudu)

  1. Click “Site Extensions” -> then Click on “Gallery” , Search for ‘PHPMyAdmin’

2. Click on the “PLUS” Sign and it’ll do an install for you, then click on “Restart Site” Button at the top Right.

3. By now the PHPMyAdmin is installed and the site has been restarted.

Configuring the PHPMyAdmin to connect with MySQL

1. In the Kudu Console, Click on “Debug Console” -> CMD

2. Click on Folder “Site Extensions” , then click on Folder “PhpMyAdmin” — the presence of this folder confirms that the phpmyadmin is indeed installed.

3. Scroll down the folder/file listing and find the file “Config.inc.php” — Click on the “Edit” Button with the “Pencil” Sign.

4. This should open and Edit Window, Find the section with configuration for $cfg[‘Servers’][$i][‘host’] and $cfg[‘Servers’][$i][‘AllowNoPassword’], set the “host” as the IP address of your MySQL installation (Put it as Localhost if the MySQL is in the same machine), and set AllowNoPassword to False, and Hit Save.

5. Go Back to “Site Extensions” and Click the button “Restart Site” on top Right.

Interesting reads

  1. Introduction to Azure Tools — https://azure.microsoft.com/en-us/blog/windows-azure-websites-online-tools-you-should-know-about/

2. Azure Website Extensions — https://channel9.msdn.com/Shows/Azure-Friday/Azure-WebSites-Site-Extensions

3. Continuous Deployment and Deployment Credentials — https://azure.microsoft.com/en-us/documentation/articles/web-sites-publish-source-control/


Originally published at www.brijrajsingh.com on January 8, 2016.

One clap, two clap, three clap, forty?

By clapping more or less, you can signal to us which stories really stand out.