Unable to connect to any of the specified MySQL hosts.

Question

Hi :

I have created database in MySql workbench. I am successfully able to get the connection object but when trying to open the connection using con.Open(), getting error as "Unable to connect to any of the specified MySQL hosts."

I am using Visual Studio 2008 Express edition and app is in C#.

Thanks,

Shailesh

Answer 1

But you can connect to MySql host with tools that comes when you install MySql? Are you using MySql ADO.NET provider or something else?

Answer 2

The error indicates several problems: You may not be authorized to open the connection of your app on a specified server host; The server is the host of your app; If your app has created a database in SQL why are trying to connect to any SQL hosts when you need to connect with Exchange to sync the database to other servers? You may have coded an open source app that has been built upon by another developer!

---

Christine Sindelar