connet mysql database remotely

#region Using directives 


using System; 
using System.Data; 
using System.Data.SqlClient; 

#endregion 

namespace testConnect1 
{ 
class SqlTest1 
{ 
static void Main() 
{ 
string connectionString = "server=localhost;database=test;uid=denis;pwd=dhoctor"; 

SqlConnection mySqlConnection = new SqlConnection(connectionString); 

string selectString = "SELECT field01, field02, field03 " + "FROM test "; 

SqlCommand mySqlCommand = mySqlConnection.CreateCommand(); 

mySqlCommand.CommandText = selectString; 

SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(); 

mySqlDataAdapter.SelectCommand = mySqlCommand; 

DataSet myDataSet = new DataSet(); 

mySqlConnection.Open(); 

Console.WriteLine("Retrieving rows from the Test table"); 
string dataTableName = "Test"; 
mySqlDataAdapter.Fill(myDataSet, dataTableName); 

DataTable myDataTable = myDataSet.Tables[dataTableName]; 

foreach (DataRow myDataRow in myDataTable.Rows) 
{ 
Console.WriteLine("Field01 = " + myDataRow["field01"]); 
Console.WriteLine("Field02 = " + myDataRow["field02"]); 
Console.WriteLine("Field03 = " + myDataRow["field03"]); 
} 

mySqlConnection.Close(); 
} 
} 
}