MySQL Bugs: #80331: Unable to connect to any of the specified MySQL hosts

Bug #80331	Unable to connect to any of the specified MySQL hosts
Submitted:	10 Feb 2016 15:45	Modified:	27 Jul 2018 13:11
Reporter:	IT Kamil	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.5.32	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
down vote
favorite
I have a website and a console application installed on a windows machine. And these applications are using a Mysql DB server which is installed on a Linux machine, The applications and DB connection works fine, but sometimes they don't -and quite randomly- I get the error 'Unable to connect to any of the specified MySQL hosts' in a email Error to me .

What I have already checked:

When i go to the windows machine and try to connect to the DB server with workbench it then works fine .
I have increased the limit of dynamic ports on the windows machine already to 50000. and quite often anyhow, when i check the number of outgoing 'Time_Wait' connections it is very negligible. Otherwise I really don't know what could i try to troubleshoot this issue , as it is quite random ... I also checked the MySQL log file log-error=/var/log/mysql55-mysqld.log , but didn't find information about access errors . Does this error means that the windows server is not able to reach the Mysql server at all ? or it reached it but something went wrong ? any ideas about this would be much appreciated ¨ Other Info : Mysql server version 5.5.32
MYsql.Data.DLL Version 6.8.3

How to repeat:
Not sure really .

Please check: https://bugs.mysql.com/bug.php?id=67043.

Hi 'Miguel Solorzano' I have no idea why you have referenced the other question , there was no solution , and i have mysql server on Linux server not on a windows one ...

Hi,

Thank you for your report.

We can not deduce what is wrong with your installation from what you have provided. What Connector do you use to login to MySQL server ???

Next, how much have you increased connect timeout ???? If you have not, please increase it, because when the server is under load you can wait longer on the connection to be established. Establishment of the TCP/IP connection between two machines can be quite complex.

Last, but not least, you are using 5.5, which is in the maintenance state where only bugs that are crashing bugs and high security bugs are worked upon.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".