Re: ERROR [HYT00] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server(10048)

[Michaela Honkova]

I found solution ^.^ (At least it worked for me). Windows XP have limitied number of ephemeral TCP ports, and even after closing them they keep them for some time in their memory, blocking the port. So you have to decrease the time they block the port and/or increase the number of ephemeral TCP ports.

Run regedit and go:
HKey_Local_Machine\ SYSTEM\ CurrentControLSet\ Services\ Tcpip\ Parameters\

Add New key of DWORD type, name it 'TcpTimedWaitDelay'
Set value for the key in between 30-300 (in decimal), its in seconds.

Add New key of DWORD type, name it 'MaxUserPort'
Set value for the key in between 5000-65534 (in decimal).

Restart the computer for the changes to take effect :)