#2002 - The server is not responding

Linuxweblog.com 04.12.2009 23:13 PhpMyAdmin Error: #2002 - The server is not responding There are various reasons for this error. Several things to check are: Edit config.inc.php file, and specify '127.0.0.1' for the $cfg setting as follows: $cfg = '127.0.0.1'; Check my.cnf file for the following entries: socket=/tmp/mysql.sockold-passwords socket=/tmp/mysql.sock Only add the 'old-passwords' mentioned above if you are using an older version of PHP . Make sure that you do not have any older versions of MySQL installed that are conflicting. Edit config.inc.php file, and specify the MySQL socket location : For example, if your MySQL socket is /tmp/mysql.sock, find the line in config.inc.php that has the $cfg setting and change it to: $cfg = '/tmp/mysql.sock'; Set the connection mode to socket by changing $cfg to: $cfg = 'socket'; If there is no such setting, simply add in the above line and re-try. Add this entry to php.ini file and restart Apache: mysql.default_socket = "/tmp/mysql.sock" Edit the config.inc.php using the phpmyadmin /setup configuration page: In the setup screen, select the end-of-line character to be '\r' if you have a Macintosh, or '\n' for a Linux machine. Disable SELinux if you are using it, and re-try. If it works, SELinux is the issue. Run the following at your mysql prompt : 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'; Ensure that this userid has appropriate access rights.

Číst celý článek >>