[ICE16]

Hi,

I'm trying to connect to a remote MySQL server using a C# application. Google found me some simple explanations, for example these two:
How to Access MySQL with C#: Using a MySQL Database with a C# Windows Application
How to connect to MySQL 5.0 using c# and mysql connector/net!
They are basically the same, they just define the connection object in different ways. Anyway, I installed MySql Connector/Net successfully, added a reference to it and added the line "using Mysql.Data.MySqlClient;" at the top. But when I ran the program, I got a runtime error saying it was "Unable to connect to any of the specified MySQL hosts". Now, the host or server I'm using is mysql8.000webhost.com (just a free server I'm using for web development), and it has been successfully tested many times with PHP applications (I can connect to it, read & write information etc.), so I guess the MySQL server itself is not the problem.

Does anyone know what the problem is?

Thanks a lot!

[digioz]

Your code may be 100% correct. The problem is by default most Shared Hosting Companies disable remote access to the database for security reason. If you are not sure, contact your web hosting company and ask them if they allow remote access to MySQL or not.

Pete