Problem to connect to mysql via c#.

[hdv212]

Hi i want to connect to mysql database that exists in customer website host via client c# app (via MySqlConnector for .net), but when connection wants to open, i got this error :

Unable to connect to any of the specified MySQL hosts.

where is my problem and how to solve it ? here is my connection string :

string conStr = "server=hostIPAddress;user id=userName; password=password; database=dbName;";

thanks

[Lost User]

read this : probably your mysql are listening only to localhost. http://stackoverflow.com/questions/938047/how-to-make-mysql-accept-connections-externally[^]

[senguptaamlan]

go to the following link to see whether al the option in the connection string are given properly or not. http://dev.mysql.com/doc/refman/5.0/en/connector-net-programming-connection-options.html[^] also see that the Port at the hosting environment is not blocked, if blocked then register in the exception list in Windows Firewall, or any firewall setting in the host computer