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

[10 Feb 2016 15:45] IT Kamil
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 .
[10 Feb 2016 23:09] Miguel Solorzano
Please check: https://bugs.mysql.com/bug.php?id=67043.
[18 Feb 2016 15:41] IT Kamil
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 ...
[27 Jun 2018 13:11] Sinisa Milivojevic
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.
[28 Jul 2018 1:00] Bugs System
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".