MY SQL error on Windows platform

Article
04/13/2018

Question

_{Friday, April 13, 2018 11:00 AM}

I am getting below error on My SQL database on Windows platform

SQLError-com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The driver was unable to create a connection due to an inability to establish the client portion of a socket.

This is usually caused by a limit on the number of sockets imposed by the operating system. This limit is usually configurable.

For Unix-based platforms, see the manual page for the 'ulimit' command. Kernel or system reconfiguration may also be required.

For Windows-based platforms, see Microsoft Knowledge Base Article 196271 (Q196271).

Arif

All replies (3)

_{Friday, April 13, 2018 1:46 PM}

Is there a specific question you have on the knowledge base article?

As MySQL is not a Microsoft product, you also might want to reach out to the MySQL experts in the MySQL forum - forums.mysql.com The experts who are working with MySQL on Windows have most likely experienced this issue in the past and may have a defined solution.

tim

_{Wednesday, April 18, 2018 9:33 AM}

Hi,

Please remember to mark useful reply as answer, which would be much more efficient for other forum community members to find useful information.

Best Regards,

William

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

_{Monday, April 23, 2018 1:53 PM}

Hi,

Just want to confirm the current situations.

Please feel free to let us know if you need further assistance.