If the library is installed in the GAC, you must include the
in your connection string. This is a new requirement as of
MySQL Connector/NET 6.6.4.
The following list shows steps and code fragments needed to run a Connector/NET application in a partial trust environment. For illustration purposes, we use the Pipe Connections protocol in this example.
Install Connector/NET: version 6.6.1 or higher, or 6.5.4 or higher.
After installing the library, make the following configuration changes:
SecurityClassessection, add a definition for the
MySqlClientPermissionclass, including the version to use.
<configuration> <mscorlib> <security> <policy> <PolicyLevel version="1"> <SecurityClasses> .... <SecurityClass Name="MySqlClientPermission" Description="MySql.Data.MySqlClient.MySqlClientPermission, MySql.Data, Version=22.214.171.124, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
Scroll down to the
<PermissionSet class="NamedPermissionSet" version="1" Name="ASP.Net">
Add a new entry for the detailed configuration of the
<IPermission class="MySqlClientPermission" version="1" Unrestricted="true"/>Note
This configuration is the most generalized way that includes all keywords.
Configure the MySQL server to accept pipe connections, by adding the
--enable-named-pipeoption on the command line. If you need more information about this, see 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
MySqlClientPermissionclass in the trust policies. (The alternative is to globally enable the permissions
Create a simple web application using Visual Studio 2010.
Add the reference in your application for the
web.configfile so that your application runs using a Medium trust level:
<system.web> <trust level="Medium"/> </system.web>
MySql.Data.MySqlClientnamespace to your server-code page.
Define the connection string, in slightly different ways depending on the Connector/NET version.
Only for 6.6.4 or later: To use the connections inside any web application that will run in Medium trust, add the new
includesecurityassertsoption to the connection string.
includesecurityasserts=truethat makes the library request the following permissions when required:
SecurityPermissionsamong others that are not granted in Medium trust levels.
For Connector/NET 6.6.3 or earlier: No special setting for security is needed within the connection string.
MySqlConnectionStringBuilder myconnString = new MySqlConnectionStringBuilder("server=localhost;User Id=root;database=test"); myconnString.PipeName = "MySQL55"; myconnString.ConnectionProtocol = MySqlConnectionProtocol.Pipe; // Following attribute is a new requirement when the library is in the GAC. // Could also be done by adding includesecurityasserts=true; to the string literal // in the constructor above. // Not needed with Connector/NET 6.6.3 and earlier. myconnString.IncludeSecurityAsserts = true;
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.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.