Configure the MySQL server to accept pipe connections, by adding the --enable-named-pipe option on the command line. If you need more information about this, see Section 2.3, “Installing MySQL on Microsoft Windows”.

Confirm that the hosting provider has installed the Connector/Net library (MySql.Data.dll) in the GAC.

Optionally, the hosting provider can avoid granting permissions globally by using the new MySqlClientPermission class in the trust policies. (The alternative is to globally enable the permissions System.Net.SocketPermission, System.Security.Permissions.ReflectionPermission, System.Net.DnsPermission, and System.Security.Permissions.SecurityPermission.)

Create a simple web application using Visual Studio 2010.

Add the reference in your application for the MySql.Data.MySqlClient library.

Edit your web.config file so that your application runs using a Medium trust level:

 <system.web>
     <trust level="Medium"/>
  </system.web>

Add the MySql.Data.MySqlClient namespace to your server-code page.

Define the connection string:

MySqlConnectionStringBuilder myconnString = new MySqlConnectionStringBuilder("server=localhost;User Id=root;database=test;"   );
          myconnString.PipeName = "MySQL55";
          myconnString.ConnectionProtocol = MySqlConnectionProtocol.Pipe;

Define the MySqlConnection to use:

MySqlConnection myconn = new MySqlConnection(myconnString.ConnectionString);
myconn.Open();

Retrieve some data from your tables:

MySqlCommand cmd = new MySqlCommand("Select * from products", myconn);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataSet1 tds = new DataSet1();
da.Fill(tds, tds.Tables[0].TableName);
GridView1.DataSource = tds;
GridView1.DataBind();
myconn.Close()

Run the program. It should execute successfully, without requiring any special code or encountering any security problems.