Configuring ASP.NET Identity to use MySQL

Question

I am using Visual Studio 2013 to develop a web forms application. I selected Authentication: Individual user accounts. I want the application including ASP Identity to use MySQL.

I added references to MySql.Data, MySql.Data.Entity.EF6, MySql.Web and have made the following changes to Web.config:

<connectionStrings>
    <add name="EkoPayMaster.Properties.Settings.EkoPayMasterConnectionString" connectionString="server=localhost;user id=root;persistsecurityinfo=True;database=paymaster" />
</connectionStrings>

    <membership defaultProvider="MySqlMembershipProvider">
      <providers>         
        <clear />
        <add name="MySqlMembershipProvider" type="MySql.Web.Security.MySQLMembershipProvider, MySql.Web" connectionStringName="EkoPayMasterConnectionString" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="/" autogenerateschema="true" />
      </providers>
    </membership>
    <profile>
      <providers>           
        <clear />
        <add type="MySql.Web.Security.MySqlProfileProvider, MySql.Web" name="MySqlProfileProvider" applicationName="/" connectionStringName="EkoPayMasterConnectionString" autogenerateschema="true" />
      </providers>
    </profile>
    <roleManager enabled="true" defaultProvider="MySqlRoleProvider">
      <providers>
        <clear />
        <add connectionStringName="EkoPayMasterConnectionString" applicationName="/" name="MySqlRoleProvider" type="MySql.Web.Security.MySQLRoleProvider, MySql.Web" autogenerateschema="true" />
      </providers>
    </roleManager>

  <entityFramework>
    <providers>
      <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" />
    </providers>
  </entityFramework>
  <system.data>
    <DbProviderFactories>
      <remove invariant="MySql.Data.MySqlClient"></remove>
      <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.8.3.0" />
    </DbProviderFactories>
  </system.data>

When I run the application, I am able to register a user and log in. However, ASP Identity does not create the necessary user tables is the MySql database.

What do I need to do to have the application add the tables/user information into MySql?

Cesar · Accepted Answer · 2014-06-17 13:52:09Z

1

First of all, as I know, you must use exactly the same connection string name you gave in connectionStrings/add name in all your providers' connectionStringName attributes.

answered Jun 17, 2014 at 13:52

Cesar

5276 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kinyanjui Kamau Over a year ago

You are right. The issue was with the connection string name and not providing enough information for <DbProviderFactories>, i.e. Version etc.

Radenko Zec Over a year ago

You have sql script together with implementation which uses ADO.NET to talk with MySQL in this blog post blog.developers.ba/asp-net-identity-2-1-for-mysql

Collectives™ on Stack Overflow

Configuring ASP.NET Identity to use MySQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related