MySQL Timeout problem handling

When the database appears with 10055 and 10048 errors, the workaround:

First link Timeout setting
(1) Open registry: regedit
Find Hkey_local_machine\system\currentcontrolset\services\tcpip\parameters\tcptimedwaitdelay

If this item is not tcptimedwaitdelay in the registry, increase the project and set the double-byte (DWORD) type value to 30

(2) Kill Administrator Explorer

(3) Restart your computer

Second dynamic port default range 49152-65535
MySQL Dynamic port
netsh int ipv4 set dynamicport tcp start=10000 num=50000
netsh int ipv4 set dynamicport UDP start=10000 num=50000
netsh int ipv6 set dynamicport tcp start=10000 num=50000
netsh int ipv6 set dynamicport UDP start=10000 num=50000

Can be written as a bat script, unified execution:

@echo off&setlocal enabledelayedexpansion
Echo TcpTimedWaitDelay 30
REG ADD "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters"/V "tcptimedwaitdelay"/t REG_DWORD/ D 30/f
echo IPv4 TCP
netsh int ipv4 set dynamicport tcp start=10000 num=50000
echo IPv4 UDP
netsh int ipv4 set dynamicport UDP start=10000 num=50000
echo IPv6 tcp
netsh int ipv6 set dynamicport tcp start=10000 num=50000
echo IPv6 udp
netsh int ipv6 set dynamicport UDP start=10000 num=50000
Pause

MySQL Timeout problem handling