Skip navigation links

MySQL Forums :: Database Administration & Monitoring :: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)


Advanced Search

<<< THE SOLUTION - SOLUTION SUMMARY >>> <<< READ THIS FIRST >>>
Posted by: Roel Van de Paar ()
Date: March 26, 2009 09:38PM

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

There are various reasons for this error.

Please try each of the following, retrying after each step.

When you find it works, please stop and do not continue down the list.

o Please edit your config.inc.php file, and specify '127.0.0.1' (instead of any other value like 'localhost) for the $cfg['Servers'][$i]['host'] setting as follows:

$cfg['Servers'][$i]['host'] = '127.0.0.1';

o Check your my.cnf file for the following entries:

[mysqld]
socket=/tmp/mysql.sock
old-passwords

[client]
socket=/tmp/mysql.sock

Only add the 'old-passwords' mentioned above if you are using an older version of PHP (PHP4).

o Make sure that you do not have any older versions of MySQL installed that are conflicting.

o Please edit your config.inc.php file, and specify the MySQL socket location (as seen in the above [mysqld] socket setting):

For example, if your MySQL socket is /tmp/mysql.sock, find the line in config.inc.php that has the $cfg['Servers'][$i]['socket'] setting and change it to:

$cfg['Servers'][$i]['socket'] = '/tmp/mysql.sock';

o Set the connection mode to socket by changing $cfg['Servers'][$i]['connect_type'] to:

$cfg['Servers'][$i]['connect_type'] = 'socket';

If there is no such setting, simply add in the above line and re-try.

o Please add this entry to your php.ini file (again changing the '/tmp/mysql.sock/' to your actual socket location) and restart Apache:

mysql.default_socket = "/tmp/mysql.sock"

o Please edit the config.inc.php using the phpmyadmin configuration page on localhost:

Access this via:

http://localhost/phpmyadmin
or
http://localhost/phpMyAdmin/scripts/setup.php

In the setup screen, select the end-of-line character to be '\r' if you have a Macintosh, or '\n' for a Linux machine.

o Disable SELinux if you are using it, and re-try. If it works, SELinux is the issue.

o Please run the following at your mysql prompt (using the standard mysql client):

mysql> SELECT USER,HOST FROM mysql.user;

Next, identify the user your are using for phpMyAdmin, and then run:

mysql> SHOW GRANTS FOR 'user'@'host';

Please ensure that this userid has appropriate access rights.

Similar thread here:
http://forums.mysql.com/read.php?35,23138,23138

Options: ReplyQuote


Subject Written By Posted
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) jamal mahdi 01/18/2006 01:21AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Viktor Berke 02/04/2006 10:27AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Niko Atmadja 02/25/2006 12:24AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Hikmat Rizal 03/11/2006 07:59AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Clinton Jones 03/16/2006 03:29AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Zhonghai Deng 09/19/2008 12:56AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Kuppu Sammy 12/30/2008 04:20AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Michael Felt 03/19/2006 05:41AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) baiewola 03/21/2006 03:23PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Michael Felt 03/31/2006 01:31AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Anil Vattalai 09/22/2006 12:56AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Yoga Nandiwardhana 01/29/2007 02:33AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) alex trimbee 06/13/2008 08:44AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) alex trimbee 06/13/2008 08:45AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Michael Valentiner 07/08/2008 01:54PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Yichao Wang 07/08/2008 11:13PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Luciano Mariante 11/07/2008 10:52AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Diana Brewster 12/09/2008 12:08PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) John Uz 12/25/2007 01:17AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Justin Lindberg 07/13/2008 01:10AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Abdelmageed khalil 08/26/2008 10:18PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) mithun zakir 11/09/2008 04:03PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Sarbjeet Singh 07/24/2007 06:33PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) manju valsan 12/11/2007 01:20AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) John Uz 12/25/2007 01:18AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) kevin yin 02/27/2008 11:02PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Radovan Hrabcak 05/02/2008 07:02AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Brian Hull 05/09/2008 08:44AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Hicham El Barouti 06/10/2008 12:43PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Travis Crowder 09/30/2008 09:23AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Luciano Mariante 11/07/2008 10:37AM
<<< THE SOLUTION - SOLUTION SUMMARY >>> <<< READ THIS FIRST >>> Roel Van de Paar 03/26/2009 09:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.