万恶的10061

今天安装mysql有报10061，而且service启动了，反而在applying security settings 报错。。真TMD讨厌
解决方法：[url]http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html[/url]
总结如下：
1、修改my.ini，在[mysqld]下面添加bind-address=0.0.0.0。解释如下：
By default MySQL (5.5 version on Windows XP) binds to "localhost" (somehow 127.0.0.1 is not same as localhost) and it will accept connections only from localhost.
Since the OS would convert localhost to 127.0.0.1 automatically, other programs are unable to connect.
(MySQL command line client might be functioning differently Because it can connect using localhost as host name.)

If you want MySQL port to listen on all interfaces add this setting to your my.ini file
bind-address=0.0.0.0
2、官方文档说按如下做（修改注册表）：
Start Registry Editor (Regedt32.exe).

Locate the following key in the registry:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
On the Edit menu, click Add Value, and then add the following registry value:

Value Name: MaxUserPort
Data Type: REG_DWORD
Value: 65534
This sets the number of ephemeral ports available to any user. The valid range is between 5000 and 65534 (decimal). The default value is 0x1388 (5000 decimal).

On the Edit menu, click Add Value, and then add the following registry value:

Value Name: TcpTimedWaitDelay
Data Type: REG_DWORD
Value: 30
This sets the number of seconds to hold a TCP port connection in TIME_WAIT state before closing. The valid range is between 0 (zero) and 300 (decimal). The default value is 0x78 (120 decimal).

Quit Registry Editor.

Reboot the machine.

3、其他的方法什么将mysql删除干净，比如删除allusers下面的msyql啊，多点几次retry，一点用都没有