MySQL Connector/NET 6.5 in partial trust

MySQL Connector/NET 6.5 introduces a new MySqlClientPermission class in trust policies. This class can be used to restrict data/MySQL access.

To prevent Security Exceptions, this SecurityClass and IPermission must be configured in the web_mediumtrust.config file.

Open the file (C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\web_mediumtrust.config) and add:

<securityclass Name="MySqlClientPermission" Description="MySql.Data.MySqlClient.MySqlClientPermission, MySql.Data, Version=6.5.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />

<!-- [...] -->

<iPermission class="MySqlClientPermission"
  version="1">
  <add connectionString="Server=;Database=;"
    restrictions="User=;User Id=;Password=;Port=;Pooling=;"
    KeyRestrictionBehavior="(PreventUsage|AllowOnly)" />
</iPermission>

Test the configuration with the following C# script:

<%@ Page Language="C#" %>
<%@ Import Namespace="MySql.Data" %>
<%@ Import Namespace="MySql.Data.MySqlClient" %>
<script runat="server">
protected void Page_Load(object sender, System.EventArgs e)
{
  MySQLConn();
}
void MySQLConn()
{
  string connStr = "Server=mysql_host;User=mysql_user;" +
    "database=mysql_db;password=mysql_passwd;";
  MySqlConnection conn = new MySqlConnection(connStr);
  try
  {
    Response.Write("Connecting to MySQL... ");
    conn.Open();
    string sql = "SELECT * FROM table_name";
    MySqlCommand cmd = new MySqlCommand(sql, conn);
    MySqlDataReader rdr = cmd.ExecuteReader();
    while (rdr.Read())
    {
      Response.Write(rdr[0]+ " " +rdr[1]);
    }
    rdr.Close();
  }
  catch (Exception ex)
  {
    Response.Write(ex.ToString());
  }
  conn.Close();
  Response.Write("Done.");
}
</script>

Did you like this post?

Please take a second to support Sysadmins of the North and donate! ❤️

Your generosity helps pay for the ongoing costs associated with running this website like coffee, hosting services, library mirrors, domain renewals, time for article research, and coffee, just to name a few. ❤️