The php backend often prompts that the connection to mysql cannot be refreshed and then accessible. bitsCN.com provides two methods on the Internet:
First:Uninstall the KB967723 patch.
Log on to the server and go to Control Panel-add and delete programs-(check "show updates" on the top). you can see the updated KB967723 patch in it, and then uninstall it just like uninstall common software, you will be prompted during uninstallation. if uninstallation may cause program running errors, it doesn't matter. select "yes" to continue uninstallation. Restart the database server after uninstalling the instance.
Type 2: modify the registry
This method is provided by Microsoft to modify the registry to fix this Bug, because the default maximum number of temporary TCP ports is 5000, which is applicable to the products included in this section. Add a new parameter to these products. To increase the upper limit of the temporary port, follow these steps:
- Start Registry Editor.
- Find the following subitem in the registry, and then clickParameters: HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Tcpip/Parameters
- InEditClickNew, 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 by the program to request any available user ports from the system. Generally, a temporary (short) port is allocated between the value of 1024 and the value of 5000.
- Exit Registry Editor and restart your computer.
The first method has been verified to solve the problem correctly, and the second method is being verified.
Address: http://support.microsoft.com/kb/q196271
Because an error occurs when you modify the registry file, we have prepared a registry file for you. you can double-click the file to run the import operation. the server has the anti-virus feature to prevent temporary cancellation of registration modification, otherwise, the data cannot be imported.
BitsCN.com