The phpMyAdmin program is a very popular open-source supplement to MySQL. For example, it is recommended by the Joomla project as the preferred way to export and import Joomla websites.

As far as I can determine, phpMyAdmin is not installable via the Microsoft Web Platform Installer, yet another reason for my very low opinion of that program. But there are several blog articles on the web about how to do it, and for the sake of completeness I'm going to document how I did it in this blog article. In this article I'll describe installing it using the same techniques described in Joomla on IIS - Part 7 - Preparing for a new website . This is quite a bit more complicated than most descriptions of how to install phpMyAdmin on IIS.

Create a disk folder for the phpMyAdmin files

The phpMyAdmin program runs as a website, so start by creating a folder inside the Websites folder for phpMyAdmin, for example C:\Websites\phpMyAdmin.

Just to be sure, you can check the permissions for this folder. It should have inherited permissions for CREATOR OWNER, SYSTEM and Administrators, and that's all.

Define the phpMyAdmin site for IIS

Start the IIS Manager program.

Expand the tree of items in the navigation panel on the left, and select the Sites entry. Then click on Add Website... over to the right, or right-click and select Add Website...

Note that the "host name" is specified based on the intention that phpMyAdmin will only be run via a local browser, i.e., no connection from anywhere on the internet.

Create an entry in the Windows hosts file for phpMyAdmin

This is described here: Editing the Windows hosts file , except that it is not necessary to change the website's bindings.

Setting Windows file permissions

This is a long and tedious procedure, and I've already explained it once here Joomla on IIS - Part 7 - Preparing for a new website , so I'll just run through the screenshots.

 

 

 

 

 

 

 

 

 

Download the phpMyAdmin files

The phpMyAdmin files can be downloaded from here: https://www.phpmyadmin.net/downloads/

The current version when this was written was 4.7.1, so the file I downloaded was phpMyAdmin-4.7.1-english.zip. You may alternatively prefer to download phpMyAdmin-4.7.1-all-languages.zip.

The files in the .zip file should then be extracted.

Copy the phpMyAdmin files to the website folder

All of the files and folders extracted from the downloaded .zip file should be copied to the website folder that was created at the start of this article, i.e., to C:\Websites\phpMyAdmin or D:\Websites\phpMyAdmin.

Just to be 100% sure that the Windows file permissions set earlier in this article are working, you could check the file permissions on C:\Websites\phpMyAdmin\doc for example, and make sure that it has inherited the Full Control permission for "user" phpMyAdmin.

Configuring phpMyAdmin

If all of the above steps have been done correctly, and the various gods of the nerd cosmos are in a good mood, it should now be possible to start and configure phpMyAdmin. Start a web browser (my personal choice is Firefox) locally on the server and enter this URL: phpmyadmin.localhost/setup

Click New server.

Enter an optional name for the server (not needed, defaults to "localhost") and click Apply.

Now click Download. This should create a file config.inc.php. Save this file in C:\Websites\phpMyAdmin.

Now you should be able to run phpMyAdmin normally, starting it with the URL: phpmyadmin.localhost.

Enter the MySQL authentication information, for example username joomla and the password specified in section Joomla on IIS - Part 6 - Installing MySQL

(The default setup for MySQL does not allow logging in using username root in this way. This blog article recommends adding a dedicated MySQL account for phpMyAdmin: http://theitbros.com/how-to-install-and-configure-phpmyadmin-on-iis-in-windows-8server-2012/ .)

You must login to post a comment.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.