Phpmyadmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. Since Windows doesn’t include a GUI  managment tool for Mysql, you will need to install phpMyadmin to acess a GUI  rather than administratering Mysql via the command line interface.

Please be sure that your php installation already has the GD/GD2 Library, Mysql and MBString extensions active. You can see this by going to your IIS server and accessing the php test page. If you do not have one, you can make one by going to “C:\inetpub\wwwroot\ and my creating a text with the following line;

<? phpinfo(); ?>

Save the file as phptest.php.

This will allow you to goto Http://localhost/phptest.php. If you don’t see the Mysql or MBstring sections, you will need to have them enabled to proceed as phpMyadmin requires this.

1. Before we begin, you will need to download the Phpmyadmin software from the distrubtion website. Head over to http://www.phpmyadmin.net/home_page/downloads.php and download the lastest release in zip format.

2. Once you have downloaded the software,you will need to extract it to  “C:\inetpub\wwwroot\phpmyadmin”.

3. Open up the IIS manager and expand the default website (This is setup by IIS 7 already, you won’t need to create this). Right click on phpmyadmin and left click on Convert to Application.

4. Leave the default settings in place and hit ok.

5. Go back to the IIS manager, highlight the default website again and click on Default Document.

6.  Next click add which is in the right side panel

7. In the dialog field, type index.php and then click ok.

8.  Now you will need to configure the Phpmyadmin software. To do this, head over to “C:\inetpub\wwwroot\phpmyadmin” and locate the config.sample.inc.php file. Open it up with either notepad, wordpad or whatever text editor you have installed on your server.

9. Find the line that says $cfg['blowfish_secret'].  You must put something between the empty single quotes in order for phpMyAdmin to work.  You can put anything here.

10. Next you will need to find the lines that say $cfg['Servers'][$i]['controluser'] and $cfg['Servers'][$i]['controlpass'] and uncomment them (remove the leading // from the front of the line).  Then you will need to change the password.  This are used for accessing advanced functions in phpMyAdmin.  Also note that it is recommended to change the username for security reason since pma is the default username.

11. Lastly you’ll need to find the advanced phpMyadmin Features and uncomment all of the lines under it.

12. Save the file as config.inc.php

13. Point your browser to http://localhost/phpmyadmin/ and you should see a login page.

Type in your username and the password you assigned to your Mysql server and then click Go.

That’s it. You have installed phpMyadmin on your IIS 7 installation.