<<< 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
<<< THE SOLUTION - SOLUTION SUMMARY >>> <<< READ THIS FIRST >>>
March 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.