title: SimpleMembershipProvider with MySQL in MVC4
body: <p>I'm facing with strange problem with SimpleMembershipProvider. I ran an example MVC4 project in VS11 and created my own database which contains table "userprofile" with two fields "UserId" and "UserName". Moreover I connected my MySQL database with Entity Framework and generated model from the DB. </p>
  
  <p>Then I tried to deal with membership provider and I faced with some problems. Actualy, I've done everything what is written in this article:</p>
  
  <p><a href="http://deresegetachew.wordpress.com/2013/01/20/websecurity-initializedatabaseconnection-throughs-an-exception-unable-to-find-the-requested-net-framework-data-provider/" rel="nofollow">http://deresegetachew.wordpress.com/2013/01/20/websecurity-initializedatabaseconnection-throughs-an-exception-unable-to-find-the-requested-net-framework-data-provider/</a></p>
  
  <p>No reason why in line with:</p>
  
  <pre><code>WebSecurity.InitializeDatabaseConnection("ParserEntities", "userprofile", "UserId", "UserName", autoCreateTables: true);
  </code></pre>
  
  <p>I'm getting an exception:</p>
  
  <blockquote>
    <p>The ASP.NET Simple Membership database could not be initialized. For more information, please see <a href="http://go.microsoft.com/fwlink/?LinkId=256588" rel="nofollow">http://go.microsoft.com/fwlink/?LinkId=256588</a>"}</p>
  </blockquote>
  
  <p>That's how my connection string looks like:</p>
  
  <pre><code>    &lt;add name="ParserEntities" connectionString="metadata=res://*/ParserModel.csdl|res://*/ParserModel.ssdl|res://*/ParserModel.msl;provider=MySql.Data.MySqlClient;provider connection string=&amp;quot;server=localhost;user id=root;database=parser&amp;quot;" providerName="System.Data.EntityClient" /&gt;
  </code></pre>
  
  <p>Thanks for any help!</p>