HowTo Fix: PhpMyAdmin Displays Blank Page After Logging In
August 16th, 2009 · Posted in HowTo, Tutorials
Recently I published an article about Windows Vista Home Premium and the “problems” I was running into when installing my programs. Well, this time I run into another problem when I installed appserv-win32-2.6.0 . Everything seemed to work just fine, Apache was working well, but when I tried opening PhpMyAdmin for some reason it was displaying a blank page after I entered my login information.
The solution to this blank page problem is fairly easy. Simply modify this line in the phpmyadmin/config.inc.php
$cfg['Servers'][$i]['host'] = ‘localhost’;
to this:
$cfg['Servers'][$i]['host'] = ‘127.0.0.1′;
In the above code, you’re changing your name server to 127.0.0.1 in order to use TCP/IP connection. After this, you should be able to see your PhpMyAdmin page by opening in your browser the address http://127.0.0.1/PhpMyAdmin
Hope this helps!
Note: Whenever you specify “localhost” or “localhost:port” as server, the MySQL client library will override this and try to connect to a local socket (named pipe on Windows). If you want to use TCP/IP, use “127.0.0.1″ instead of “localhost”. If the MySQL client library tries to connect to the wrong local socket, you should set the correct path as Runtime Configuration in your PHP configuration and leave the server field blank.
My name is Karina Myers, I'm a web designer & developer located in Michigan, US. This is one of my spaces on the web. I'm also the co-owner of Web Development/Design and Web Hosting Company Tablóx Web Solutions. To learn more about my work visit my portfolio, and services page. You may contact me, even if it's just to say "hello". I'd love to hear from you!
September 27th, 2009 at %I:%M %p
Yes it helped … thank you
November 25th, 2009 at %I:%M %p
man ….., pretty and smart
November 26th, 2009 at %I:%M %p
Thanks a bunch. I struggled with this issue for an entire day
November 29th, 2009 at %I:%M %p
just what I was looking for.. Thank you!
December 29th, 2009 at %I:%M %p
[...] Of course, I didn’t know that at the time as phpMyAdmin just displays a blank page. I found this article by Karina Myers that described a workaround – specify 127.0.0.1 for the host instead of local host. [...]
December 30th, 2009 at %I:%M %p
Wasted so many hours with that problem..you saved my day. Thanks a lot!
January 7th, 2010 at %I:%M %p
Thanks everybody! Nice comments like these make me want to create more useful post like this one.
Karina
January 21st, 2010 at %I:%M %p
Easy but great solution.
It works on windows 7 too.
Thanks a lot:)
January 23rd, 2010 at %I:%M %p
Hell, I’ve been struggling with W7AMP & especially phpmyadmin for several hours now. Thank God & especially you for this blog
rgds
February 14th, 2010 at %I:%M %p
Thanks!!!
February 20th, 2010 at %I:%M %p
short and simple. thanks
February 20th, 2010 at %I:%M %p
thank you, thank you, thank you .. after 6 hours of trying i finally found the solution :))) thank you very much!
February 24th, 2010 at %I:%M %p
thank you very much Karina, you are a life savier
March 2nd, 2010 at %I:%M %p
OMG, struggled for a whole day! Thanks a lot for this.
March 2nd, 2010 at %I:%M %p
after long and long hours searching on the internet and nothing
you finally solved my problem
Thanks !!
March 3rd, 2010 at %I:%M %p
This solution will help. Thx to Karina. But try this configuaration:
$cfg['PmaAbsoluteUri'] = ‘http://localhost/phpmyadmin/’;
Now I can start phpMyAdmin with ‘localhost’.
Philipp
March 4th, 2010 at %I:%M %p
Sorry, this shouldn’t be spam, but i think there is another solution, based on the note that karin write in her post. I have the problem with windows 7 and there was no host information in the file C:\Windows\System32\drivers\etc\hosts. Check this Link: http://www.windowsreference.com/windows-7/edit-hosts-file-in-windows-7-windows-vista/
With the folling information in this file, localhost will work by connecting mysql:
127.0.0.1 localhost
Philipp
March 4th, 2010 at %I:%M %p
very good advise:)
tks
March 5th, 2010 at %I:%M %p
I spent about 12 hours trying to figure out a way out of this most irritating and frustrating problem. You saved my day and my weekend. Thank you so much!
March 6th, 2010 at %I:%M %p
You seriously are my hero!
March 7th, 2010 at %I:%M %p
Thanks a lot, it was very usefull!!!!