How do i connect a windows C# application to a remote Mysql database?

2 responses to “How do i connect a windows C# application to a remote Mysql database?”

1. 
   wallmeister

   March 10, 2011 at 11:36 am | Permalink

   It’s the same for a remote database as local. When you set up the data source, just specify the remote server.

2. 
   Rott

   March 10, 2011 at 11:54 am | Permalink

   You need to install the drivers to setup an ODBC connection which can be found here:

   http://www.mysql.com/products/connector/

   After you have the drivers installed, setup your DSN to connect to your remote mysql database. You will likely need to add your ip to the Remote Database Access Hosts depending on how the Mysql server is configured.

   You will then be able to use code as follows (replace the DSN name “test” with the name you provide when creating the DSN):

   using System.Data.Odbc;
   OdbcConnection DbConnection = new OdbcConnection(“DSN=test”);
   DbConnection.Open();

   OdbcCommand DbCommand = DbCommand.CommandText = “SELECT * FROM TABLE”;
   OdbcDataReader DbReader = DbCommand.ExecuteReader();DbConnection.CreateCommand();