<div mce_keep="true">MYSQL 5.1.39 (community version and Essential)</div>
<div mce_keep="true">phpMyAdmin 3.2.3</div>
<div mce_keep="true">PHP 5.2.11</div>
<div mce_keep="true">Windows 2k8 R2</div>
I was able to install phpMyAdmin properly and the site is running well. I can login with my MySQL credentials and can manage all the database. I also tried with PHP 5.3 and it worked with that too.
I am not sure why you are getting into this. Can you tell more please.
This problem turned out to be that I had not enabled TCP networking on MySQL as a security measure. I uninstalled and reinstalled everything, this time enabling networking and it worked.
Please ensure that at the time of installing MySQL you have checked 'Enable TCP/IP Networking' and port number set to 3306. But before you do a reinstallation please ensure below things:
<div mce_keep="true">Your PHP installation is correct and a simple PHPINFO page is displayed properly.</div>
<div mce_keep="true">Are you able to login to MySQL using MySQL command line utility by giving root password?</div>
DavidRPotter
11 Posts
Can't get phpMyAdmin to work on Server 2008 R2
Nov 01, 2009 09:04 AM|LINK
I just installed Windows Server 2008 R2 and got IIS fully installed. I installed the following:
I created the phpMyAdmin config.inc.php as described on my blog (which I've used on several occasions):
http://dpotter.net/Technical/2009/03/installing-phpmyadmin-on-windows-and-iis-60/
I am able to navigate to my phpmyadmin URL and I get the login page. However, after waiting about 30 seconds, the following page is displayed:
<div id=header>Server Error in Application "DEFAULT WEB SITE/PHPMYADMIN"
</div> <div id=server_version>Internet Information Services 7.5
</div> <div id=content> <div class=content-container> </div> <div class=content-container> </div> <div class=content-container> </div> <div class=content-container> </div> <div class=content-container> </div></div>I've been searching the forums for a couple hours now and haven't found anything that will solve this. Can someone help?
Thanks,
David
FastCGI phpMyadmin 5.3.0 HTTP Error 500 Windows Server 2008 R2 IIS 7.5
don.raman
1207 Posts
Microsoft
Moderator
Re: Can't get phpMyAdmin to work on Server 2008 R2
Nov 02, 2009 10:06 PM|LINK
Hi,
I used below configuration:
I was able to install phpMyAdmin properly and the site is running well. I can login with my MySQL credentials and can manage all the database. I also tried with PHP 5.3 and it worked with that too.
I am not sure why you are getting into this. Can you tell more please.
Thanks,
Don.
don.raman
1207 Posts
Microsoft
Moderator
Re: Can't get phpMyAdmin to work on Server 2008 R2
Nov 02, 2009 10:08 PM|LINK
BTW, I tried exactly similar configuration with PHP 5.2.11 on Vista SP2 too. And it works there too.
Thanks,
Don.
DavidRPotter
11 Posts
Re: Can't get phpMyAdmin to work on Server 2008 R2
Nov 06, 2009 12:59 AM|LINK
This problem turned out to be that I had not enabled TCP networking on MySQL as a security measure. I uninstalled and reinstalled everything, this time enabling networking and it worked.
Thanks for the help.
David
wang2013
9 Posts
Re: Can't get phpMyAdmin to work on Server 2008 R2
Dec 31, 2009 04:08 AM|LINK
I am having the same problem. tell me the detail on how you enable TCP networking on MySQL as a security measure. thanks
don.raman
1207 Posts
Microsoft
Moderator
Re: Can't get phpMyAdmin to work on Server 2008 R2
Dec 31, 2009 06:10 PM|LINK
Hi,
Please ensure that at the time of installing MySQL you have checked 'Enable TCP/IP Networking' and port number set to 3306. But before you do a reinstallation please ensure below things:
There is lot of material on the Web which will tell you step by step instruction to install MySQL on Windows. I have found http://www.ricocheting.com/server/mysql.html useful.
Thanks,
Don.
wang2013
9 Posts
Re: Can't get phpMyAdmin to work on Server 2008 R2
Jan 02, 2010 01:20 AM|LINK
I am running Windows Web Server 2008 at my home. the URL: http://project.dyndns.ws/phpinfo.php
I checked Php and MySQL. they both are working fine. I am not sure why I can not open phpMyAdmin after log on (http://project.dyndns.ws/phpmyAdmin/ )
If you have any ideas, please let me know. thanks.
don.raman
1207 Posts
Microsoft
Moderator
Re: Can't get phpMyAdmin to work on Server 2008 R2
Jan 02, 2010 01:29 AM|LINK
Hi,
Please do not give username/password in the forum, it can be bad. What error message you are getting when you are trying to login?
Thanks,
Don.
wang2013
9 Posts
Re: Can't get phpMyAdmin to work on Server 2008 R2
Jan 02, 2010 01:47 AM|LINK
Thanks for the quick response. I got the error message on my computer client below
500 - Internal server error.
There is a problem with the resource you are looking for, and it cannot be displayed.
I checked my server and ran a test. I got the error message with more details below
HTTP Error 500.0 - Internal Server ErrorThe page cannot be displayed because an internal server error has occurred.Detailed Error InformationModule
Requested URL
don.raman
1207 Posts
Microsoft
Moderator
Re: Can't get phpMyAdmin to work on Server 2008 R2
Jan 02, 2010 02:02 AM|LINK
So you are not even getting the login page. Right?
Thanks,
Don.