string MyConnection2 = "datasource=localhost;port=3307;username=root;password=root";  
        //Display query  
        string Query = "SHOW VARIABLES;";  
        MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);  
        MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);               
        MyConn2.Open();  
       //For offline connection we weill use  MySqlDataAdapter class.  
       MySqlDataAdapter MyAdapter = new MySqlDataAdapter();    
       MyAdapter.SelectCommand = MyCommand2;  
       DataTable dTable = new DataTable();  
       MyAdapter.Fill(dTable);