Subscribe to the TST RSS Feed
Train Signal RSS Feed
Subscribe to the TST RSS Feed to get Real-Time Updates
Train Signal RSS by Email
Or recieve our RSS Feed via Email
Install PHPMyAdmin on IIS7 and Server 2008
After installing our copy of MySQL on IIS7 and Server 2008, you might be wondering what to do next.
Well if you don’t feel like learning the command line sequences for MySQL you might be interested in using a web based GUI based tool which will make managing the databases a lot easier.
This tool is called PHPMyAdmin and can be found at www.phpmyadmin.net.
What will you be able to do with PHPMyAdmin in the database?
Here is a list of some of the features:
- browse and drop databases, tables, views, fields and indexes
- create, copy, drop, rename and alter databases, tables, fields and indexes
- maintenance server, databases and tables, with proposals on server configuration
- execute, edit and bookmark any SQL-statement, even batch-queries
- load text files into tables
- administer multiple servers
- create and read dumps of tables
- search globally in a database or a subset of it
And that is just the short list of features of this very powerful application. It recently was named Best of Open Source Platforms and Middleware by Infoworld.
Note: PHPMyAdmin requires both PHP and MySql to be installed on the server. If you need to please refer back to my articles on installing them:
Download and Install PHPMyAdmin
Ok so now that we know why we should install it, let’s get to the actual installation part.
But before we begin, let’s go download the software at: www.phpmyadmin.net/home_page/downloads.php.
The current version as I write this article is 2.11.9, so I am going to go ahead and download that to get started. Which version you use will depend on your environment; I am going to use the english.zip for this demo. Let’s get started!
1. Extract the files from the archive to a site that is available on the web server (remember the application is web based).
For this demo I am going to use C:\inetpub\wwwroot\phpmyadmin
2. Now start IIS Manager and expand the default website; right click on phpmyadmin and left click on Convert to Application.
3. You can leave the default settings in place for the Add Application window and click OK.
4. Create a folder to save your PHP sessions; for our example I am going to use C:\temp\phpsessions and give full rights to the following users:
IUSR
IIS_IUSRS
Network Service
5. Now go into your php directory and find php.ini — we have to make a few changes:
Find session.save_path and set it to the same as you used in step 4 which in our case is C:\temp\phpsessions and save the file.
6. Please note that this application requires the following extensions for PHP:
MySQL
GD
MBSTRING
If you do not have these on your server already, please install them. If you are using my article to install PHP then in step 6 just add the above extensions to your installation, or if you already installed it rerun the installer msi file and modify your installation to include these extensions.
To check if they are installed do a search for extension=php_mysql in the php.ini and you should see it uncommented.
Do the same for the other extensions:
extension=php_gd2.dll
extension=php_mbstring.dll
7. Go into IIS Manager, go to the default site (that is if you have been following my demo, if you have been modifying your site location or path then use that) and click on Default Document.
8. In the right pane click Add…
9. In the dialog box type index.php and click Ok.
10. Go to the directory that you unzipped PHPMyAdmin to and look for a file named config.sample.inc.php and open it in Wordpad. (You can use notepad but it tends to jumble everything up)
11. Now find the line $cfg[‘blowfish_secret’] = ‘’; you have to fill in this line with anything that you want but it needs to be a value.
Only up to 46 characters and it can be alphanumeric. In this case I am going to use trainsignal1111TST
12. Go down to you see the section User for advanced features and uncomment (Remove the // from the front of the line) the two lines under that and change the pmapass to a different password, for this demo I am going to use trainsignal.
13. next, go down to the next section Advanced phpMyadmin features and uncomment all the lines under it (remove the // from the front of the line).
14. Now save this file as config.inc.php
15. Point your browser to http://localhost/phpmyadmin/ (if you have been following this example; if you have used a different site/directory then point to that) and you should see a login page.
Type in the userid and password for your local MySql server, then click Go.
16. Now you are in and able to manage your MySql instance!
As a quick test let’s create a database by scrolling to the Database link and clicking on it
17. Type in the name of your new database, for this example I am going to use Trainsignaltraining and then click Create.
18. You will now see a page that confirms that database Trainsignaltraining has been created.
That’s all there is to it, now you can quickly and easily manage you MySql databases on IIS7 through PHPMyAdmin.
Related Articles
Install MySQL on IIS7 Server 2008 (September 10, 2008)
IIS 7: Install FastCGI & PHP on Server 2008 (September 4, 2008)
Troubleshooting IIS 7: Examining Trace Failed Request Logs (July 9, 2008)
Remote Administration of IIS 7: Isolate & Delegate (June 17, 2008)
Remote Administration of IIS 7: Install, Configure, Connect (June 11, 2008)
How to Setup User Authentication in FTP 7 on IIS 7.0 (April 30, 2008)
Installing FTP Publishing Service for IIS 7.0 (April 25, 2008)
HTTP Redirection in IIS 7 on Windows Server 2008 (March 27, 2008)
How to Install IIS 7 & Setup a Static Website in 13 Easy Steps (March 21, 2008)
17 Responses to “Install PHPMyAdmin on IIS7 and Server 2008”
Leave A Comment:
Subscribe To Our eNewsletter
Chris Perry Says:
October 7th, 2008 at 3:03 pm
I’ve followed this to the letter and have phpMyAdmin working for the most part, but I’m seeing the warning message “Connection for controluser as defined in your configuration failed.” on every page. Any clues as to what I’m looking for to fix it?
Chris Perry Says:
October 9th, 2008 at 4:43 am
Fixed it. Just had to change ‘controluser’ from “PMA” to “root”
David Lawlor Says:
October 9th, 2008 at 10:42 am
Chris-
Sorry I wasn’t able to get back to you on this right away, it was on my list but it seems the list never gets shorter. I am glad you were able to find an answer to your problem, and thanks even more for posting again with your answer.
Best Regards,
Dave
How to get MySQL and PHPMyAdmin working with IIS7 and Windows 2008: BillS IIS Blog Says:
October 14th, 2008 at 1:58 pm
[...] PHPMyAdmin, for those who haven’t used it before, is a handy PHP app that lets you do database administration via your Web browser. Handy for getting a database or user created, running ad hoc queries, and so forth. Learn how to install it by reading this tutorial: Install PHPMyAdmin on IIS7 and Server 2008 [...]
jeff Says:
November 2nd, 2008 at 2:35 pm
Hey Dave,
i get the following warning after i’ve done the setup and launched the main phpmyadmin page:
Cannot load mcrypt extension. Please check your PHP configuration.
I can still log into phpmyadmin, but this bothers me. I’ll send another comment with my findings.
thanks again for the fantastic articles!!
jeff
Kennedy Says:
November 12th, 2008 at 12:34 pm
Hello!
I just recently created my first server and i have no idea how to complete step 4. you said “Create a folder to save your PHP sessions; for our example I am going to use C:\temp\phpsessions and give full rights to the following users:
IUSR
IIS_IUSRS
Network Service
”
but where? how? once i clicked “ok” to create the phpmyadmin into an application, i dont know what to do.
Kennedy Says:
November 12th, 2008 at 12:49 pm
I found out how to do it. never thank you!
but right now i am getting an error message #1045 :
You probably did not create a configuration file. You might want to use setup script to create one.
Error
MySQL said: Documentation
#1045 - Access denied for user ‘root’@'localhost’ (using password: NO)
what should i do?
Tony Montana Says:
November 26th, 2008 at 3:10 am
Hi Dave, You are a ruddy star!
I have been looking for a tut like this for ages but since I am a novice and the other articles are so complex I get lost very quickly and get disheartened. I have followed a few of your articles on setting up IIS7, PHP on IIS, MySql and not only have I been able to follow them but they have worked too! (I installed themk on my Vista machine which I hope to use as my test server but the instructions were exactly the same.)
I just got one problem that I was wondering if you could help with and it is the same as Jeff’s post on 02.11.08. I get the following error…
Cannot load mcrypt extension. Please check your PHP configuration.
and I wonder if this is because when I was loading the extensions, in the PHP install, MBSTRING was not present as an option. (I installed the php-5.2.6-nts-win32-installer.msi - which I think is the one you recommended.)
I plan to start my web development as an xmas project, as a complete novice, and I cannot thank you enough for getting me started. I didn’t even know there was a decent version of IIS and that it would support PHP.
I’m gonna use the sitepoint book ‘Build Your Own Database Driven Website Using PHP & MySQL’ to help me but would you be able to recommend a good resource?
Thanks for all your help so far
Tony
James Says:
December 3rd, 2008 at 11:10 am
Cannot load mcrypt extension. Please check your PHP configuration.
Same Error here
LPG Says:
December 11th, 2008 at 1:18 pm
To fix the mcrypt problem, you need to install the mcrypt extension for php. To do this..
Run the php installer that you originally ran to install php, select “change” when asked what you want to do, and when you get to the page that says “choose items to install” select the extension “mycrypt”.
I have a different problem I was hoping someone could help me with though. Once I login to phpmyadmin, at the bottom it says “Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.30. This may cause unpredictable behavior.” I can’t find a solution to this, does anyone know please?
-LPG
David Lawlor Says:
December 11th, 2008 at 2:22 pm
LPG -
What versions of PHPMyAdmin are you using? I am seeing some bug reports popping up about this but it looks like most of them started on the 9th when the newest versions were released.
Dave
LPG Says:
December 11th, 2008 at 2:50 pm
I installed phpMyAdmin 3.1.1. Because of your comment though I uninstalled it just now and put 2.11.9 on the system and I’m receiving the same error. Perhaps it’s because I have MySQL 5.1 installed instead of 5.0. So I suppose the latest releases of everything aren’t currently compatible with each other…
-LPG
David Lawlor Says:
December 11th, 2008 at 2:55 pm
That is actually what I was looking at, I would look for a version of PHP that is around the same date as the MySQL release.
LPG Says:
December 11th, 2008 at 4:03 pm
Installing MySQL 5.0.67 with phpMyAdmin 3.1.1 worked. Thank you for your help and thank you for the article!
David Lawlor Says:
December 11th, 2008 at 4:11 pm
LPG-
No problem at all! Glad you got it working!
Dave
Chris Says:
December 15th, 2008 at 12:24 am
Hello,
I have installed MySQL as per your document. I have also downloaded the latest PHPMyAdmin version 3.1.1 and installed Everything appears to be configured correctly, however when I try login through the PHPMyadmin website, the login page simply “loops”. I.e. I put in my credentials and without any error returns me back to the blank login page again. If I use legit and non-legit login details it does the same thing. It would appear as if it’s not even trying to Authenticate me.
Any help on this would be much appreciated.
THanks
Chris
Mason Says:
December 29th, 2008 at 7:29 am
hey friends, i am db user and was recommeneded by my friends to take a look at sqlyog best mysql administrative tool which i found awesome. When i started with this i was new born baby to use and i din find hard to use it. Too friendly take a look and enjoy!!!