IIS 7: Install phpMyAdmin on Windows 7



phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web.


You can download phpMyadmin at http://www.phpmyadmin.net/home_page/downloads.php You can choose from 'All Languages' or 'English' versions

The latest version (currently 3.2.5) is found at the top of the page.

It may be downloaded in various compression formats, being .7z or .tar.bz2 or .tar.gz or .zip

In this guide we will download the English zip file, which can be easily extracted on a Windows 7 machine without additional downloads.


Once you have doenloaded the zip file and turned off any antivirus or firewall you are ready to start




Open the folder you downloaded to and right click and click Extract All...




Step 2

Select a destination folder.

I have used the default folder which is the same folder the zip file was downloaded to

Click on Extract




Step 3

Screen shot below shows file being extracted by Windows 7





Open the location where you extracted the file

Open the folder phpMyAdmin-X.X.X-english (where X is the version number)




Step 5

The file you find in there will have the same file name.

You need to rename it phpmyadmin




Step 6

Right click the renamed file and Copy it to clipboard - right click and select Copy from list





Navigate to your web server root (C:\Inetpub\wwwroot) and paste the file there




Step 8

Open the phpmyadmin folder you pasted and create a new folder and name it config

Now close all open folders




Step 9

Open your Browser and type http://localhost/phpmyadmin/setup/index.php

This opens the configuration page

Ignore the security warnings as they are intended for server administrators installing phpMyAdmin on an internet server

On the bottom of the page click on New Server





You are required to set up the php configuration for your computer as follows

Check the following settins, some of which are entered by default

Server hostname: localhost

Connection Type: tcp

PHP extension to use: mysql

Authentication type: config

User for config auth: root

Password for config auth: Your MySQL root password


Scroll down and click Save




Step 11

The phpMyAdmin Overview page opens


Ignore any warnings


Under Servers ensure localhost appears under Name


Now close browser




Step 12

Navigate to your phpmyadmin folder (C:\Inetpub\wwwroot\phpmyadmin)

Open the config folder



Step 13

Right click and copy the file config.inc




Step 14

Paste the config file to phpmyadmin folder (C:\Inetpub\wwwroot\phpmyadmin)


The official instructions instruct you to delete the config folder, however this is not necessary in a local testing environment



Step 15

Close all folders

Open Web Browser and type in http://localhost/phpmyadmin/ to start setting up your databases


Congratulations! - you have now created a PHP development environment.


NOTES: If you can not connect to MySQL and receive an error message from http://localhost/phpmyadmin/ it is more than likely an error in config.php file

Click here to download a very basic text file example

Go to phpmyadmin folder (C:\Inetpub\wwwroot\phpmyadmin) and open config file & compare to downloaded sample

The only modification required is changing the password in file & save to phpmyadmin folder (C:\Inetpub\wwwroot\phpmyadmin) with file name config.php as a text file

It would be prudent to first rename the existing config file configOLD.php prior to saving file, just in case you need it later.

There is a more detailed sample file already in your phpmyadmin folder (C:\Inetpub\wwwroot\phpmyadmin) that can also be used called config.sample.inc.php (just rename config.inc.php)



Related Articles


Change Control Panel View on Windows 7


Disable User Account Control (UAC) on Windows 7


Install and Configure IIS 7.5 & PHP & FastCGI on Windows 7




Install MySQL on IIS 7.5 on Windows 7