How to resolve MySQL connection errors 10055

Products

• CA Spectrum

Issue/Introduction

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

Release: Spectrum 10.2 installed on Windows 2008
Component:

Resolution

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