Connection to MySql

   

using System;
using System.Data;
using ByteFX.Data.MySqlClient;

   class MySqlConnect
   {
      static void Main() 
      {
         string connString = @"Data Source=server;Database=mydb;User ID=username;Password=pwd;Command Logging=false";
         MySqlConnection conn = new MySqlConnection(connString);

         try 
         {
            conn.Open();
            Console.WriteLine("Connection opened.");

            Console.WriteLine("Connection Properties:");   
            Console.WriteLine("	Connection String: {0}",conn.ConnectionString);    
            Console.WriteLine("	Database: {0}",conn.Database);   
            Console.WriteLine("	ServerVersion: {0}",
               conn.ServerVersion);
            Console.WriteLine(
               "	State: {0}",
               conn.State);
         } 
         catch (MySqlException e) 
         {
            Console.WriteLine("Error: " + e);  
         }
         finally 
         {
            conn.Close();
            Console.WriteLine("Connection closed.");
         }
      }
   }