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

[Irwan Hassan]

Hi all,

I was having the same problem.

MySQL Server 5.1.32, MySQL.Net Connector 5.2.5 and using Visual Studio 2008 on Windows Vista.

I use three different PC/Laptop to develop my application. I was able to connect to the server without any problem in Windows XP SP3 but Windows Vista can't. So I though it could be Windows Firewall block the connection, but I can use MySQL Query Browser to connect to the specific database.

My Connection String was :
Data Source=localhost;Database=MyDatabase;User ID=MyDBUser;Password=MyPassword;Port=MyPort;

It was keep on denying. So I change the Data Source from localhost to my computer name. It worked without any problem. So I guess this could be something to do with security on Windows Vista. Anyway, it worked.

I guess it may solve your problems too.