The server is unresponsive (or the socket for the local MySQL server is not configured correctly) The first case: (Deep cleanup garbage causes host.) MyD lost) Like many netizens! With Wamp (or XAMPP, speedphp) It is easy to quickly build a server environment on your XP, Win7 system so that you can test the drift lit php+mysql site locally, start Wamp, The browser opens the Http://localhost/phpmyadmin, can open the database normally ... All right, crap is here! Problem here: When I use "Rubik's Cube" of ' deep clean trash ', start Wamp again, browser opens Http://localhost/phpmyadmin, "#2002 server does not respond (or ...). www.2cto.com problem causes: host. MyD file is missing, host. The myd file is a 0-byte file that does not have any content, but is called when MySQL is started, writes some temporary letters , and ' Rubik's Cube ' Deep clean garbage, I choose to scan empty files and empty folders, will host. MyD Scan to and delete, start Wamp again, the problem arises as above; I thinking about the host. The MyD property is set to ' Read Only ' to prevent me from accidentally deleting it, but I made an unforgivable low-level error, host. MyD is ' Read Only ', then MySQL cannot in host. MyD write temporary information, the result is to start Wamp, the browser opens Http://localhost/phpmyadmin, still appears "#2002 server does not respond (or ...)". Solution: When installing Wamp for the first time, locate host in the installation directory. MYD, whose path is "C:\wamp\bin\mysql\mysql5.5.20\data\mysql\host." MYD (i default install WAMP in C packing directory) ", you can choose to back up a host. MYD, or create a new empty "text document. txt" To change it to "host." MYD ", placed under its correct path, i.e. . Second scenario: (Firewall blocking causes MySQL to fail to start) Reason: The local MySQL server is not started workaround: First, find the installation path for MySQL D:\Program files\mysql\mysql Server 5.1\bin Second, double-click the Mysqld.exe file, if Windows Firewall pops up the block prompt, click Unblock to www.2cto.com third case: ( MySQL socket file binding IP is invalid) reason: If a host name is not specified or a special hostname of localhost is specified, UNIX sockets will be used, and the UNIX socket defaults to/tmp/mysql.sock, and the native is not configured to do so socket file, so the connection failed naturally. WORKAROUND: Locate the phpMyAdmin folder under Wamp\phpmyadmin (depending on the path you installed), find the config.inc.php file, and open it with notepad (Notepad) to find $cfg[' Servers ' [$i] [' host '] = ' localhost '; this line, then change the localhost here to 127.0.0.1. There is a netizen suggestion to add Add $cfg[' Servers ' [$i] [' hide_db '] = ' informatio N_schema ';//Use the login to see the INFORMATION_SCHEMA database, this sentence actually does not add also does not matter. Detailed view of official documents:http://dev.mysql.com/doc/refman/5.1/zh/index.html author Elinstudiohttp://www.2cto.com/database/201207/139519.html
The "Go" server is unresponsive (or the local MySQL server socket is not configured correctly)