Was the MySQL installation configured to allow TCP/IP connections,
this is a good example for installing MySQL on a Windows system[
^].
Try one of the
admin tools that are available[
^] and see if it can connect to your remote server.
If MySQL is configured correctly the next thing is your
connection string[
^] which one you use is dependent on which MySqlConnection you are using.
Some connection string exmaples are:
The standard MySQL supplied connection it should be;
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
If you are using the one created by the MySQLDriverCS project team it would be;
Location=myServerAddress;Data Source=myDataBase;User ID=myUsername;Password=myPassword;Port=3306;Extended Properties="""";