Re: MySqlException: Unable to connect to any of the specified MySQL hosts

[rene98c]

So ,as I understand you have server application working day by day (24/7) .And after certain time interval passes, server app connects to mysql, retrieves/stores some data. am I Right?
And sometimes, it connects and sometimes not?

If connection string is like:

("user id = root;database=mysql;host=localhost,password=root")

comma is separator,not semicolon
And mysql takes host name as "localhost,password=root".
And exception is thrown when host is incorrect.

But that was not the case with you.I tried this, with small application
to be sure.

If sometimes connects and sometimes not, maybe theres some problem down to physical
data layer, like cables or switches, that messes with your mind.

Of course this only my opinion.