KB967723 patch caused by MySQL on the Win2003 frequently not connected to the problem of solution _ server Other

One might ask, why does the patch 9th appear, only to find the problem now? As we all know, the server is not restarted every day, some servers may be one months or Yinianbanzai reboot once, and some may be restarted after September 9 server, so the patch is effective (I personally think so). Symptom: Can ' t connect to MySQL server on ' localhost ' (10061)

Solution:

Old method: uninstall KB967723 Patch: Login to the server, Access Control Panel-Add and Remove Programs-(check above "Show Update") in which you can see the updated KB967723 this patch, and then want to uninstall the same as ordinary software uninstall, uninstall will prompt you, If the uninstall may cause the program to run wrong, it doesn't matter, select Yes to continue uninstalling. Uninstall completes after the program server, everything is OK!

New method: Microsoft gives ... important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems can occur if the registry is incorrectly modified. Therefore, please ensure that these steps are carefully implemented. Before you add a protection registry, you should back up your modifications. You can then restore the registry when a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the appropriate in the Microsoft Knowledge Base:

322756 (http://support.microsoft.com/kb/322756/) How to back up and restore in the Windows registry

The default maximum number of temporary TCP ports is 5000 for the products included in the section. Add a new parameter to these products. To increase the upper limit of the temporary port, follow these steps:

1. Start Registry Editor. ( start-run-regedit)
2. Locate the following subkey in the registry, and then click Parameters : hkey_local_machine\system\currentcontrolset\services\tcpip\parameters
3. Click New on the Edit menu, and then add the following registry key: Value name: maxuserport
   Value type: DWORD
   Value data: 65534 ( note is decimal)
   Valid range: 5000-65534 (decimal)
   Default value: 0x1388 (50,000)
   Description: This parameter uses the maximum number of ports used by the control program to request any available user ports from the system. Typically, a temporary (short) port is assigned between the value of 1024 and the contained 5000.
4. Quit Registry Editor and restart the computer.

Note that the other TcpTimedWaitDelay registry parameters determine how long the port is closed, and so on, that can be reused. Microsoft original link: http://support.microsoft.com/kb/q196271