The server has no response (or the socket on the local MySQL server is not correctly configured ).

The server has no response (or the socket on the local MySQL server is not correctly configured). The first case is: (the host. MYD is lost due to deep garbage cleaning! With wamp (or xampp, speedphp), you can easily build a server environment on your XP and Win7 systems. In this way, you can locally test the beautiful Php + mysql website and start wamp, open the browser http://localhost/phpmyadmin Can open the database normally ...... Okay, it's time to go! Here is the problem: when I use the "cube"'s 'deep garbage clean', I start wamp again and open it in the browser. http://localhost/phpmyadmin , "#2002 server does not respond (or...)" appears ......)". Www.2cto.com cause: host. MYD file loss, host. the MYD file is a 0-byte file, which does not contain any content. However, it is called when mysql is started and some temporary messages are written, while the 'CUBE 'is used to clean up garbage in depth, I select to scan Empty files and empty folders, and then host. MYD has been scanned and deleted. If wamp is started again, the above problem occurs. the MYD attribute is set to 'readonly' to prevent accidental deletion, but I am making an unforgivable low-level error, host. if MYD is 'readonly', mysql cannot be stored in the host. write Temporary Information in MYD. The result is to start wamp and open it in the browser. http://localhost/phpmyadmin , "#2002 server does not respond (or...)" still appears ......)". Solution: Find the host in the installation directory when wamp is installed for the first time. the path of MYD is "C: \ wamp \ bin \ mysql \ mysql5.5.20 \ data \ mysql \ host. MYD (I installed wamp in the C root directory by default) ", you can choose to upload a host.myd, then create an empty text file. txt" and change it to "host. MYD, put it in the correct path. Case 2: (mysql cannot be started due to firewall blocking) cause: the local mysql server is not started. Solution: Step 1. Find the mysql installation path D: \ Program Files \ MySQL Server 5.1 \ bin part 2, double-click the mysqld.exe file. If the windows Firewall prompts a blocking prompt box, click unblocking to go to www.2cto.com. Case 3: (the ip address bound to the mysql socket file is invalid) cause: If no host name is specified or a special host name localhost is specified, Unix socket is used. The default value of Unix socket is/tmp/mysql. sock, and the local machine does not configure such a socket file, so naturally the connection fails. Solution: Find the phpmyadmin folder under wamp \ phpmyadmin (depending on the path you have installed) and find config. inc. open the PHP file with notepad (notepad) and other software and find $ cfg ['servers'] [$ I] ['host'] = 'localhost'; this line, modify the localhost to 127.0.0.1. Some netizens suggest adding $ cfg ['servers'] [$ I] ['hide _ db'] = 'information _ scheme'; // The information_schema database is invisible after login, it doesn't matter if this sentence is not added. For details, see the official documentation: http://dev.mysql.com/doc/refman/5.1/zh/index.html Author elinstudio