IIS 7: Install phpMyAdmin on Windows 7

Introduction

 

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

 

STEP 1

 

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

 

 

STEP 4

 

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

 

 

STEP 7

 

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

 

 

STEP 10

 

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

 

Windows_7_Install_mcrypt_extension_and_libmcrypt_dll_for_PHP

 

Install MySQL on IIS 7.5 on Windows 7