How to resolve MySQL connection errors 10055

Document ID : KB000045391
Last Modified Date : 14/02/2018
Show Technical Document Details

Summary: 

MySQL Error Code 10055: 

ERROR HY000 MySQLODBC 5.1 DriverCan't connect to MySQL server on 'localhost' (10055) ERROR HY000 MySQLODBC 5.1 DriverCan't connect to MySQL server on 'localhost' (10055)

This error actually indicates a problem at the operating system (OS) level rather than a MySQL error.

Windows uses a random high range of dynamic ports.  What is happening is there are not enough ports to facilitate the request.

Increasing the amount of ports will effectively resolve the problem.

Environment:  

Windows Server operating systems 2008+

Instructions: 

1. Open a Windows Command Prompt on the server as Administrator

2. Type in the following commands:

netsh int ipv4 set dynamicport tcp start=10000 num=50000

netsh int ipv4 set dynamicport udp start=10000 num=50000

Spectrum does not use IPv6 for this but we can increase those ports as well while we are at it:

netsh int ipv6 set dynamicport tcp start=10000 num=50000

netsh int ipv6 set dynamicport udp start=10000 num=50000

3. Restart MySQL and Spectrum Tomcat services