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 Posts:
- Install MySQL on IIS7 Server 2008
- IIS 7: Install FastCGI PHP on Server 2008
- Installing WordPress on IIS 7 – Part 1
- IIS7: URL Rewrite Extension on Windows Server 2008
- Install Read-Only Domain Controller on Windows Server 2008
- Microsoft Web Application Installer
- How to Install LAMP in Ubuntu 9.10
71 Responses to “Install PHPMyAdmin on IIS7 and Server 2008”
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!!!
S.m. Says:
January 21st, 2009 at 5:33 pm
I love your tutorials about PHP, MYSQL, PHPMYADMIN! im working on my graduation… building a Content Manament System and i needed a testing server at home! Thx and keep up the good work!
Lana Says:
February 5th, 2009 at 2:52 pm
Hey!
I have been reading and following ALL you tutorials. THANK YOU !
But i can’t log in. Where did i go wrong?
#1045 – Access denied for user ‘root’@'localhost’ (using password: YES)
Lana Says:
February 5th, 2009 at 3:01 pm
Sorry, never mind. I was trying to log in with the password which i just wrote in the config file …. after thinking about it, i came to my senses and used the U/P for my MySQL. It works now. Thank you!
Thomas Says:
February 11th, 2009 at 1:18 am
Thank you for doing the complete tutorials phpmyadmin, FastCGI & PHP, and mysql, I have completed all three and have everything running error dree, finally but I have one final obstacle and i have looked everywhere for the answer but I can’t seen to beat this one.
Everything is perfect until I try to import sql data to phpmyadmin from another server. I have tried very way I can think of but I still get an error every time i try to import. “File could not be read” That it it just fails and says that and nothing else. I can save and export dump but I cant import at all.
Please if you have seen this before let me know where I have gone wrong. I have been hung up for days
David Potter Says:
March 12th, 2009 at 2:30 pm
This was extremely helpful. Thanks so much for publishing this.
I found on another site (http://www.aota.net/PHP_and_MySQL/phpmyadmin.php4) that the advanced features username and password don’t need to be specified unless the authentication type is set to ‘config’. Since the default value for that setting is ‘cookie’ I decided not to set the username and password it worked fine. What do you think? If you can verify this, you may want to remove the steps about setting those settings.
Thanks,
David
Michal Knoller Says:
March 24th, 2009 at 3:47 am
I have already installed mysql and php (after weeks of trying) – now for phpmyadmin I found your explanation very clearand easy to use.
I got as far as //localhost… and the phpmyadmin doesnt work and now neither does the PHP (which i’ve been using)!!! can you help me??
Amster Says:
March 31st, 2009 at 9:31 pm
Hello there. Again, amazing tutorial thanks. Just one snag – as per Chris Perry’s comment above, I too had the “Connection for controluser as defined in your configuration failed” error once logged into phpMyAdmin, however, after changing controluser to root and controlpass to the same password as that I had defined MySql – the message disappeared.
Thanks again :)
Guillaume Says:
May 6th, 2009 at 9:06 am
hello
Hint:
For people they got error with phpmyadmin ”File could not be read ” just check
open_basedir in your php.ini if it set to C:\ (i have use C:\inetpub like this tutorial but got this error and replace open_basedir to c:\ and it solve all my problem :D
Sorry guy’s for my bad english :P
David Lawlor Says:
May 7th, 2009 at 2:11 pm
The fix from Guillaume would work if your files are not under a directory under the C:\inetpub folder. This demo assumes that you have a setup similar to my install PHP demo where I specified that.
Thanks Guillaume for helping out!
Demi Says:
May 13th, 2009 at 5:05 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
”
Can someone please explain how to do this. This question was asked earlier but no solution was ever posted. Thanks.
Scott Says:
May 19th, 2009 at 8:17 am
Do you know if this will work with MySQL Express 2008? Please advise, getting ready to do this install.
thanks in advance!
SP
TroyC Says:
May 29th, 2009 at 12:34 pm
I went through all the steps in this fine article and everything was going great until its was time to open http://localhost/phpmyadmin/. I get the following error:
Warning: require_once(./libraries/common.inc.php) [function.require-once]: failed to open stream: Permission denied in C:\Inetpub\wwwroot\phpmyadmin\index.php on line 34
Fatal error: require_once() [function.require]: Failed opening required ‘./libraries/common.inc.php’ (include_path=’.;C:\php5\pear’) in C:\Inetpub\wwwroot\phpmyadmin\index.php on line 34
Will someone please help me? Thank you
michael Says:
July 2nd, 2009 at 11:57 pm
Hei TroyC
You don’t have set the permissions as described.
Just modify the permissions in C:\inetpub\wwwroot for the user IIS_IUSRS to read&execute, list folder contents and read.
That’s all you have to do :)
David Says:
July 10th, 2009 at 2:22 pm
Hi Troy
This help it’s awesome, i can install MySQL without any problem and running phpmyadmin in IIS 7 on Windows Vista. But when i run phpMyAdmin, i get the following error message:
“The additional features for working with linked tables have been deactivated. To find out why click here.”
I’m just starting working with php and MySQL and I don’t really understand why I allways get this error.
Regards
David
Tiger Says:
July 13th, 2009 at 5:38 pm
Fantastic Guide – i’m almost there but once i log into phpmyadmin i get the error
The additional features for working with linked tables have been deactivated. To find out why click here.
any ideas ? (when i click here i dont really understand what the guide is talking bout)
do i actually need a to create a database called phpmyadmin?
Billy Says:
July 14th, 2009 at 10:33 am
I need help. I am having the same issue as the first post stated “Connection for controluser as defined in your configuration failed.”
He said he fixed it by changing it from PMA to ROOT. Where do I go and change this?
I am also getting these 2 errors?
“The additional features for working with linked tables have been deactivated.”
and
“Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.36. This may cause unpredictable behavior.”
I have my WP blog up installed on my iis7 on server 2008 and have my DNS pointing their, it all works “http://wthaynes.com” BUT It is blank when trying to go to wp-admin. when I go to wp-login.php, it pulls up until I sign in, then blank again.
Please help. Thanks abunch.
Mordecai Says:
August 4th, 2009 at 1:31 am
Hi!, I just finish installing PHP5, MySQL on IIS 7 all worked out well.
However, when I installed phpmyadmin this is the error I gat…
“phpMyAdmin – Error
Cannot load mysql extension. Please check your PHP configuration. – Documentation”
I’ve tried setting the php.ini file with the php_mysql extension but to no avail. Can you please help me out?
Josh Says:
August 19th, 2009 at 10:15 am
Hi, I am having the same problem as the person who just posted. PHP and MySQL is working but i cant get myphpadmin to work. This is the error i’m getting:
Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.
Does someone know how to fix this?
Great articles by the way!!
Bob Says:
October 1st, 2009 at 1:37 pm
Hi,
I’ve followed Daves’s excellent, step-by-step instructions for installing all kinds of software and everything works fine, except for the following errors with phpmyadmin.
Cannot load mcrypt extension. Please check your PHP configuration.
I’ve added the code in the php.ini file as advised and the dll is in the ext folder.
The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.
I’ve added the code in the php.ini file as advised and the dll is in the ext folder.
The configuration file now needs a secret passphrase (blowfish_secret).
I’ve done this and made sure it was not commented out.
Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.39. This may cause unpredictable behavior.
Is this the libmysql.dll?
And then there’s this….
$cfg['Servers'][$i]['pmadb'] … not OK [ Documentation ]
$cfg['Servers'][$i]['relation'] … not OK [ Documentation ]
General relation features: Disabled
$cfg['Servers'][$i]['table_info'] … not OK [ Documentation ]
Display Features: Disabled
$cfg['Servers'][$i]['table_coords'] … not OK [ Documentation ]
$cfg['Servers'][$i]['pdf_pages'] … not OK [ Documentation ]
Creation of PDFs: Disabled
$cfg['Servers'][$i]['column_info'] … not OK [ Documentation ]
Displaying Column Comments: Disabled
Bookmarked SQL query: Disabled
Browser transformation: Disabled
$cfg['Servers'][$i]['history'] … not OK [ Documentation ]
SQL history: Disabled
$cfg['Servers'][$i]['designer_coords'] … not OK [ Documentation ]
Designer: Disabled
Help with any or all of these errors is greatly appreciated
Thanks
Bob
richdev Says:
October 13th, 2009 at 4:10 am
followed your TUT but keep getting the following error?
#0 PMA_sendHeaderLocation(http://localhost/phpmyadmin/index.php?token=a15158e53ee2b40dfebaaf27cf3a99ff) called at [G:\inetpub\wwwroot\phpmyadmin\libraries\auth\cookie.auth.lib.php:628]
#1 PMA_auth_set_user() called at [G:\inetpub\wwwroot\phpmyadmin\libraries\common.inc.php:829]
#2 require_once(G:\inetpub\wwwroot\phpmyadmin\libraries\common.inc.php) called at [G:\inetpub\wwwroot\phpmyadmin\index.php:35]
Im new to IIS so its probably simple but buggered if i know what it is.
thanks Rich
Lynn Breaux Says:
October 16th, 2009 at 11:53 am
I’m in the same shape as Bob above. The mbstring looked to be in the default extensions, but I did not see it in the ini file. I am also getting these errors when starting phpmyadmin:
The additional features for working with linked tables have been deactivated. To find out why click here.
Cannot load mcrypt extension. Please check your PHP configuration.
The configuration file now needs a secret passphrase (blowfish_secret).
When I click the here link, I get this:
$cfg['Servers'][$i]['pmadb'] … OK
$cfg['Servers'][$i]['relation'] … not OK [ Documentation ]
General relation features: Disabled
$cfg['Servers'][$i]['table_info'] … not OK [ Documentation ]
Display Features: Disabled
$cfg['Servers'][$i]['table_coords'] … not OK [ Documentation ]
$cfg['Servers'][$i]['pdf_pages'] … not OK [ Documentation ]
Creation of PDFs: Disabled
$cfg['Servers'][$i]['column_info'] … not OK [ Documentation ]
Displaying Column Comments: Disabled
Bookmarked SQL query: Disabled
Browser transformation: Disabled
$cfg['Servers'][$i]['history'] … not OK [ Documentation ]
SQL history: Disabled
$cfg['Servers'][$i]['designer_coords'] … not OK [ Documentation ]
Designer: Disabled
Lynn Breaux Says:
October 16th, 2009 at 3:04 pm
I figured out the blowfish thing. I had replaced blowfish_secret with my secret instead of putting my secret in between the two quotes after the = sign.
Thanks anyway,
Lynn
I am sill getting this error:
The additional features for working with linked tables have been deactivated. To find out why click here.
Carlos Piedrahita Says:
October 18th, 2009 at 8:12 pm
I have this problem whit the instalation of the phpmyadmin and too whit joomla instalation.
whats the problem?
thank you
Server Error in Application “Default Web Site/phpmyadmin”
HTTP Error 404.4 – Not Found
Description: The resource you are looking for does not have a handler associated with it.
Error Code: 0×80070002
Notification: MapRequestHandler
Module: IIS Web Core
Requested URL: http://localhost:80/phpmyadmin/
Physical Path: C:\inetpub\wwwroot\phpmyadmin\
Logon User: Anonymous
Logon Method: Anonymous
Handler: Not yet determined
Most likely causes:
* The file extension for the requested URL does not have a handler configured to process the request on the Web server.
What you can try:
* If the file extension does not have a handler associated with it, add a handler mapping for the extension.
* Verify that the handler associated with the file extension is properly installed and configured.
* Create a tracing rule to track failed requests for this HTTP status code. For more information about creating a tracing rule for failed requests, click here.
Alternative a PhpMyAdmin Says:
October 23rd, 2009 at 1:47 pm
[...] PhpMyAdmin non è semplicissimo da installare su IIS 7 e Windows 2008 (vi giro a tal proposito un’utile guida) [...]
Paul Says:
November 10th, 2009 at 2:43 pm
Hello all:
Just a quick one relating to the second post…
Chris Perry Says:
October 9th, 2008 at 4:43 am
Fixed it. Just had to change ‘controluser’ from “PMA” to “root”
Could you tell me where this is changed please as I have the same issue.
Much appriciated
Paul
Russ Cobb Says:
November 13th, 2009 at 9:31 am
Hi Dave,
Thanks so mucn for these tutorials. They’re fanstastic.
I followed your lessons for installing PHP for IIS 7 on Windows 2008 and I just did the one for phpMyAdmin. I ran PHP installer per your instructions, including the extentions (and PHP is running fine) but I still don’t see the following extensions in my php.ini file at all:
extension=php_mysql
extension=php_gd2.dll
extension=php_mbstring.dll
And of course, when I try to run phpMyAdmin, I’m getting the error:
“Cannot load mysql extension. Please check your PHP configuration. – Documentation”
What I do have at the bottom of my php.ini file is:
; Local Variables:
; tab-width: 4
; End:
[PHP_MSSQL]
extension=php_mssql.dll
Can you suggest what I might’ve done wrong?
Thanks so much in advance.
Russ
Richard Says:
November 21st, 2009 at 11:10 am
Everything went fine and it was a great tutorial, but when I goto the phpmyadmin login page I get:
HTTP Error 403.14 – Forbidden
The Web server is configured to not list the contents of this directory
Now it gives a possible workaround in the error, simply enable directory browsing in IIS under Default Web Site and hey presto all you then do is goto http://localhost/phpmyadmin and click on the phpmyadmin-3.2 folder listed. That then brings up the login page.
But how do I fix this to go straight to the login page when entering http://localhost/phpmyadmin , as shown above in the tutorial?
Thanks in advance
Richard
Richard Says:
November 21st, 2009 at 11:28 am
Bit rusty on IIS, didnt notice I had put the phpmyadmin folder too deep and brought it back up a folder, that fixed that problem.
I then had the “Connection for controluser as defined in your configuration failed” which as described above changed the controluser = ‘root’ and controlpass = ‘[mysqlpassword]‘ this fixed the problem.
Now I just get the $cfg not OK [Documentation] errors, but these should affect the functionality too much.
Thanks again
Richard
Dave Juian Says:
November 28th, 2009 at 8:56 pm
Ive spent all morning on this.. followed the tute to the letter (twice) and still get ‘cannot start session without errors …’ any one have any ideas? IIs7 php and mysql(all all latest versions) work fine
by the way in step 4 adding full rights to IUSR, IIS_IUSRS and Network Service
right click on the folder select properties/ security / edit and add. Simply add the users and select full control. Any way thats how I didi it.. but I still havent got it working so im no expert.
Also restart IIS after changing php.ini.
Thanks for the tute anyway Ill try again later.
King Wilder Says:
January 8th, 2010 at 1:19 pm
I finally got this to kind of work, at least I’m getting the phpMyAdmin interface, but I’m getting a few warnings and errors:
I have a screenshot of my page here: http://www.gizmobeach.com/downloads/phpmyadminerrors.jpg
Any ideas?
Thanks.
King Wilder Says:
January 8th, 2010 at 1:20 pm
Sorry, also, is it generally not acceptable to use the Web Platform Installer to install PHP on Windows Server 2008?
Thanks.
King Wilder Says:
January 8th, 2010 at 1:23 pm
I also have a screenshot of the “Additional Features” error.
http://www.gizmobeach.com/downloads/phpmyadminconfigerrors.jpg
TL Chang Says:
February 9th, 2010 at 4:04 am
Hi,
I have downloaded phpMyAdmin-2.11.10-english.zip and extracted all the contents.
When I reached step:
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.
* The problem is that I could not find “php.ini” in the extracted php directory.
Is this because of phpmyadmin version issue?
Thanks you.
Mark Layton Says:
February 17th, 2010 at 4:00 pm
Had a problem after everything was installed – browser times out after a few minutes and I get the http: 500 page – error codes etc
Found the answer over on the MySQL forum. Seems this is a quirk in Windows – In the config.inc.php file you need to change
$cfg[$i]['host'] = ‘localhost’;
to
$cfg['Servers'][$i]['host'] = ‘127.0.0.1′;
For some reason they are not recognized by Windows 7 as being the same. (it runs fine without the change on my XP machine)
johnboy Says:
February 19th, 2010 at 5:06 am
had this too and discovered another fix while searching high and low. PHP 5.3 and up has a conflict with dns in windows 7 and server 2008. Browse to the hosts file in windows\system32\drivers\etc\hosts and open in notepad and remove the comment (#) in fron of 127.0.0.,1. Make sure that the 2nd line ::1 localhost is commented out.
php 5.2 does not display this issue.
hope this helps others
DaveW Says:
February 24th, 2010 at 12:14 am
Dave – thanks for the great initial writeup.
Johnboy – THANK YOU for the >v5.2x update!!!!!!!! I have been searching for hours on why my login to phpmyadmin wasn’t working after following these instructions (server error 500 or #202 server isn’t responding). Commenting the ::1 as you stated solved the problem.
My setup is:
Windows server 2008
phpMyAdmin-3.3.0
php-5.3.1
mysql-essential-5.1.44
DaveW
David Says:
March 3rd, 2010 at 5:46 pm
AAH THANK YOU MARK LAYTON!! :D
Took me many hours to find that answer :D
Glen7901 Says:
April 12th, 2010 at 8:14 am
Thanks Mark Layton- you’re helping spread some of the best technology on the web…
-Windows 7-
php working, looks like mysql installed properly…amazing…
but was getting a just blank screen after logging into phpmyadmin
Wanted to say that johnboy’s solution above fixed this. Again:
“Browse to the hosts file in windows\system32\drivers\etc\hosts and open in notepad and remove the comment (#) in front of 127.0.0.,1. Make sure that the 2nd line ::1 localhost is commented out.”
Glen7901 Says:
April 12th, 2010 at 8:18 am
Don’t forget to run iisreset.exe after making changes….
Andrew Says:
April 20th, 2010 at 11:02 pm
Hi Dave,
I have followed you TUT carefuly. All was good till I try to login to phpMyAdmin.
After few minutes I got error:
“#2002 -The server is not responding (or the local MySQL server’s socket is not correctly configured)”
and at the bottom:
“Connection for controluser as defined in your configuration failed.”
I have tryed to change user & password to root & [SQLpassword] as described above but nothing has changed.
My configuration:
Windows SBS 2008 (64bit) Standard
IIS 7
MySQL 5.1.44 essential-win32
php-5.3.2.nts-Win32
phpMyAdmin-3.3.0
Can you help, please?
I am not familiar with this topic, but one of our client wish PHP up & running :)
Don Says:
April 21st, 2010 at 7:48 am
That’s it…. I’ve been installing, reinstalling, reading, reinstalling… And that’s all there is to it. I have tried virtually every other method of installing MySQL, IIS7, PHP, and phpMyAdmin without success. Instructions have been incomplete, out of date, or just plain stupid; anything but correct. I can across yours during a moment of extreme frustration last night and I cannot believe how easy it is. Of course nothing is hard if you know how to do it.
Thanks a bunch,
Don
Samantha Says:
April 30th, 2010 at 11:36 am
I am having the exact same issue as Andrew, did you find a solution?
Ulises Says:
May 1st, 2010 at 8:08 am
Johnboy & DaveW
Thanks for the tips !! It really worked. Andrew, Don and Samantha, please read the tips that Jonhboy and DaveW wrote I think are the solution for the eror #2002.
Matt Says:
May 3rd, 2010 at 7:11 am
For the #2002 Error in SBS 2008 (and likely Server 2008 as well)
The error seems to be that “localhost” is not properly resolved to 127.0.0.1, Try using 127.0.0.1 as the host to see if this is your issue. If it works with 127.0.0.1 then your problem is in your host file.
to fix
1. Go to C:\Windows\System32\drivers\etc
2. Open “hosts” in your fav text editor
you will likely see 2 lines:
127.0.0.1 localhost
::1 localhost
3. Comment out the “::1″ line
4. save
5. Try phpmyadmin again.
Solved the problem for me on SBS 08
Source: http://forums.mysql.com/read.php?52,294772,294772#msg-294772 (in the replies)
Matt Says:
May 4th, 2010 at 12:00 am
Ohh dear…
Use my earlier post with caution.
Seems that SBS 2008 and Server 2008 R2 rely heavily on IPV6 for a lot of internal functions.. The above will fix your #2002 error, yes, but will cause the machine to take several minutes to boot as it tries to resolve the local IPV6 address..The system will hang on “Applying computer settings”
Looking for an alternative solutions now.
JF Says:
May 7th, 2010 at 8:59 am
Thanks a lot for the hosts solution folks! That was exactly the thing that was bugging me. As for the IPv6 Solution, It’ll be a good thing, but in the meanwhile, I think its “ok” to continue with this solution.
Josh Says:
June 8th, 2010 at 11:32 pm
For the people who are getting the errors at the bottom of the page such as “The additional features for working with linked tables have been deactivated. To find out why click here.” you need to create the relational database for the additional features. Simply create a new database and name it “phpMyAdmin” or something (whatever you like) then in the config.inc.php file change $cfg['Servers'][$i]['pmadb'] to that database, then in the /scripts/ folder find the “create_tables.sql” file, copy the contents, and in phpMyAdmin in the new database you created click the SQL link and paste the sql. Run it and then exit and log back in and it should be fixed.
chris Says:
June 14th, 2010 at 4:37 am
Hi,
great guide!!
im havnig trouble to find php.ini
i have extracted files but there is no php.ini
Any ideas thanks
Jack Says:
June 30th, 2010 at 12:52 pm
Hi,
Great guide. Everything is up except that when I go to myserver.com/phpmyadmin and login, it loops back to login page. When I use incorrect mySQL login credentials it displays incorrect login, but when I use the correct ones, it just loops. I can get into myserver.com/phpadmin/setup.
Please help!
Thanks,
Yosh Says:
June 30th, 2010 at 1:19 pm
Josh! Thanks for the fix regarding errors at the bottom of the page such as “The additional features for working with linked tables have been deactivated. To find out why click here.”
Worked like a charm after logging out then back into phpmyadmin.
Edgar_DR Says:
July 8th, 2010 at 4:56 am
Hi,
I’ve been following all the steps to install php+mysql+phpmyadmin. Finally I arrived at the point where I have the “Welcome to phpMyAdmin” page and I have to fill the username and password. I’ve tryed the one of the mysql configuration “root” + “pwdchosen4me”. And also tryed with the one from config.inc.php “$cfg['Servers'][$i]['controluser'] = ‘pma’;
$cfg['Servers'][$i]['controlpass'] = ‘trainsignal’;”
(initially I left the same as in the tutorial for this step). And I can not have access further, always says after a long white screen:
“#2002 Cannot log in to the MySQL server” – “Connection for controluser as defined in your configuration failed”.
I think I didn’t miss any steps. Could you help me please?
Thank you so much!
Edgar_DR Says:
July 8th, 2010 at 5:03 am
Also I wasn’t able tu give full rights to “Network Service” because it seems that doessn’t exist. It could be a problem? Any thought?
Edgar DR
Jim Says:
July 27th, 2010 at 7:44 am
I also had the “#2002 Cannot log in to the MySQL server” error, I solved replacing “localhost” with “127.0.0.1″ in config.inc.php ($cfg['Servers'][$i]['host'] = ‘127.0.0.1′;).
Hope it helps! ;-)
Mads Says:
August 27th, 2010 at 11:09 pm
Great guide. Worked out of the box with these small “fixes”:
#1 Use root as ‘Control User’
#2 Use Joshs comment above to fix “The additional features for working with linked tales have been deactivated. To find out why click here.”
#3 Remember to write NETWORK SERVICE with capitals when giving rights til the phpsession folder – otherwise you can’t find it.
(This does not fix missing mcrypt extension to php and different mysql and mysql php client versions)