The "Go" server is unresponsive (or the local MySQL server socket is not configured correctly)

Source: Internet
Author: User

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)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.