Page 1 of 1

phpmyadmin not working [Solved]

PostPosted: 24. February 2012 23:41
by puma10
Hey guys, I just installed xampp 1.7.7 and I having trouble getting phpmyadmin to work. When trying to access I get this error message "#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)". I install all programs on my slave drive (E:) to keep the operating system drive clear (C:). I installed xampp at E:\progam_files\. Xampp control panel says MYSQL is running. Also when typing localhost in the browser I get nothing but when typing the physical ip xampp/index.php loads.

Any ideas? Perhaps because I installed on a sub directory or on my slave disk.

Thanks so much in advance.

Re: phpmyadmin not working

PostPosted: 25. February 2012 00:19
by hackattack142
You can try binding it to localhost as this sometimes fixes that issue.

Open your my.ini file (/xampp/mysql/bin/my.ini) and change
Code: Select all
#bind-address="127.0.0.1"

to
Code: Select all
bind-address="127.0.0.1"

and restart MySQL if it is running.

Now, make sure to also manually refresh that phpMyAdmin page so you do not load a cached error page.

Re: phpmyadmin not working

PostPosted: 25. February 2012 03:22
by puma10
hackattack142, thank you for the quick response. I appreciate it, unfortunately it didn't work. Any other suggestions?

Re: phpmyadmin not working

PostPosted: 25. February 2012 05:00
by hackattack142
Make sure your HOSTS file is correct for the localhost issue:
Open this file: C:\Windows\Sytem32\Drivers\etc\HOSTS

Then find the following line and remove the leading '#' character.

Code: Select all
    #   127.0.0.1       localhost

If it is not there then add that line without the hash as the first line after all the comments.

Re: phpmyadmin not working

PostPosted: 26. February 2012 01:59
by puma10
PURE MAGIC. That solved the problem, thank you hackattack142! :D

Re: phpmyadmin not working [Solved]

PostPosted: 06. June 2012 18:47
by hubiedo
the first solution worked for me w/ win xp and new install of xammp. the second solution given above was already set up with the local host setting but it was entered twice and i removed one instance of it.

wow i appreciate the help