title: Unable to retrieve stored procedure metadata for routine
body: <p>When I try to execute procedure from C# I get this error:</p>
  
  <pre><code>Unable to retrieve stored procedure metadata for routine 'test'. Either grant SELECT privilege to mysql.proc for this user or use "check parameters=false" with your connection string.
  </code></pre>
  
  <p>And this is connection string: </p>
  
  <pre><code>&lt;add name="MySqlCS" connectionString="Data Source=192.168.x.x;Initial Catalog=z;Persist Security Info=True;User ID=y;Password=y providerName="MySql.Data.MySqlClient"/&gt;
  </code></pre>
  
  <p>And then I tried adding this <code>"check parameters=false"</code></p>
  
  <p>And I get this:</p>
  
  <pre><code>Access denied for user 'y'@'pcname.domain.local' (using password: YES)
  </code></pre>
  
  <p>And new config is:</p>
  
  <pre><code>&lt;add name="MySqlCS" connectionString="Data Source=192.168.x.x;Initial Catalog=z;Persist Security Info=True;User ID=y;Password=y CheckParameters=false" providerName="MySql.Data.MySqlClient"/&gt;
  </code></pre>
  
  <p>I can connect from MySQL Workbench with same credentials with no problem at all.</p>
  
  <p>Here is C# code:</p>
  
  <pre><code>public static DataSet GetTest(string cname)
          {
              try
              {
                  OpenConnection();
  
  
                  DataTable[] tables = new DataTable[2];
  
  
                  IDbCommand cmd = myConnection.CreateCommand();
                  cmd.CommandType = CommandType.StoredProcedure;
                  cmd.CommandText = "test";
  
                  IDataParameter parCode = cmd.CreateParameter();
                  parCode.ParameterName = "Client";
                  parCode.DbType = DbType.String;
                  parCode.Value = cname;
                  parCode.Direction = ParameterDirection.Input;
  
                  cmd.Parameters.Add(parCode);
  
                  //cmd.ExecuteReader();
  
                  IDataReader dr = cmd.ExecuteReader();
                  DataSet dset = new DataSet();
                  dset.Load(dr, LoadOption.PreserveChanges, tables);
  
                  return dset;
  
              }
              finally
              {
                  CloseConnection();
              }
          }
  </code></pre>