using System.Data;

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("\tConnection String: {0}",conn.ConnectionString);

Console.WriteLine("\tDatabase: {0}",conn.Database);

Console.WriteLine("\tServerVersion: {0}",

conn.ServerVersion);

Console.WriteLine(

"\tState: {0}",

conn.State);

catch (MySqlException e)

Console.WriteLine("Error: " + e);

finally

conn.Close();

Console.WriteLine("Connection closed.");