PHPMyAdmin Socket problem

He has: 83 posts

Joined: Feb 2005

Ok first off, I hope I'm posting this in the right place.

I just installed phpMyAdmin on my webserver but I'm having problems getting it to load.

the error message said the socket could be setup incorrectly on the server so I ran a PHPINFO page to see what socket my database was using and typed that in but I'm still gettin the same error.

$cfg['Servers'][$i]['socket']        = '/tmp/mysql.sock';          // Path to the socket - leave blank for default socket
?>
'

The error code follows

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

JeevesBond's picture

He has: 3,956 posts

Joined: Jun 2002

Isn't there somewhere you can configure it to use the hostname/port (should be 3306 by default) instead of a socket on the local machine? I'll check the documentation if you can't find it yourself.

Also is the username setup correctly for both localhost and remote connections from another host if needed? I've had instances - only using an install on Windows however - where exactly the same thing happens if the server is down or the username/password is wrong.

Give those things a try and let us know how you get on. Smiling

a Padded Cell our articles site!

He has: 83 posts

Joined: Feb 2005

I have been trying to make it work now but I still cant seem to figure out what I'm doing wrong

I'm not sure this matters but the website is hosted on a linux server with GoDaddy.

The Username and Pass are correct. And I dont have a clue how I would configure it not to use the port. I even posted my delima at PHPmyadmins help forums but got 0 responses.

JeevesBond's picture

He has: 3,956 posts

Joined: Jun 2002

So have you installed phpmyadmin yourself or is this something your host has provided?

I'm presuming the phpinfo(); didn't show anything of interest? Probably not.

Have you tried connecting to a database via php, just with simple code and seeing whether this can connect and if not what error PHP returns (am assuming PHPMyAdmin is wrapping the error in its own handling here.)

Also, could you tell us the exact error message from both PHPMyAdmin and your own code? This will help track the problem down, once we have a cause we can find the solution!

a Padded Cell our articles site!

He has: 83 posts

Joined: Feb 2005

phpmyadmin is something I installed myself.

I have PHPBB2 installed on the server and everything works on there fine so I can assume the server is working right?

The only error code Im getting is from phpmyadmin #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

He has: 83 posts

Joined: Feb 2005

How would I get command line access to my websites server from my windows computer?

He has: 83 posts

Joined: Feb 2005

Ok I guess this problem is solved, I found out the host already has PHPmyadmin installed in the the control panel. Oops lol

JeevesBond's picture

He has: 3,956 posts

Joined: Jun 2002

Excellent, well sorry we couldn't have been more help! Sad

Glad you found a solution and thanks for letting us know what it was. Smiling

They have: 1 posts

Joined: May 2011

hiiiiiiii i m rtying to open phpmyadmin on my local pc but this error displaying....

plzzzzzz tell me what should i do.

i am using wamp
Error

MySQL said: Documentation
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

zani's picture

He has: 2 posts

Joined: May 2011

my problem is also same faced/

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.