Microsoft patch KB967723 causes MySQL to fail to connect frequently

The MySQL database server is frequently disconnected. It is installed under the Windows system MySQL The application of the Microsoft KB967723 patch results in two methods:

Type 1: Uninstall KB967723 patch
Log in to the server, enter the control panel - Add and Remove Programs - (check the "Display Update" above). You can see the updated KB967723 patch in it, and then uninstall it just like you uninstall ordinary software. You will be prompted during the uninstallation. If the uninstallation may cause an error in the operation of the program, it does not matter. Select "Yes" to continue uninstalling. Restart the database server after uninstallation.

The second is to modify the registry
This method is Microsoft's method to modify the registry to fix the bug, because 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 temporary ports, follow these steps:
Start Registry Editor.
Find the following subkey in the registry of, and then click Parameters:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
Click New on the Edit menu, and then add the following registry key:
Value name: MaxUserPort
Value type: DWORD
Value data: 65534
Valid range: 5000-65534 (decimal)
Default value: 0x1388 (5000 decimal)
Note: This parameter controls the maximum number of ports used when the program requests any available user port from the system. Generally, temporary (short) ports are allocated between the value of 1024 and the included 5000.
Exit Registry Editor and restart the computer.

Appreciation

see SQL registry MySQL KB967723 Related articles for

Please specify that the original article of this website is reproduced from To be kicked , Link: https://itlu.net/articles/1168.html

Comment list (1)

  1. MySQL or Linux host is not suitable for Windows

Add a comment

Hello! #Please fill in the information# determine

Reward the blogger for drinking water
 LOADING