Mysql membership/role provider

Question

0.00/5 (No votes)

See more:

I have no success in connecting to MySql database for asp.net membership. I have an empty database, and when I use the ASP Configuration tool I get the message that no providers are specified. Can someone suggest what works? Here is my connection string and membership section in the web.config.

<connectionStrings>
    <add name="MySqlMembershipConnection"
        connectionString="server=localhost;user id=root;persistsecurityinfo=True;password=bobby;database=bsgdb;"
        providerName="MySql.Data.MySqlClient"/>
  </connectionStrings>

<membership defaultProvider="MySqlMembershipProvider">
      <providers>
        <clear/>
        <add name="MySqlMembershipProvider"
              type="MySql.Web.Security.MySQLMembershipProvider, MySql.Web, Version=6.9.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"
                connectionStringName="MySqlMembershipConnection"
                enablePasswordRetrieval="false"
                enablePasswordReset="true"
                requiresQuestionAndAnswer="false"
                requiresUniqueEmail="true"
                passwordFormat="Hashed"
                maxInvalidPasswordAttempts="5"
                minRequiredPasswordLength="6"
                minRequiredNonalphanumericCharacters="0"
                passwordAttemptWindow="10"
                applicationName="/"
                autogenerateschema="true"/>
      </providers>
    </membership>

What I have tried:

I have tried everything that I can find. Nothing works. I have not changed anything in my machine.config as one source suggested. I don't know where it is. I am using Windows 7.

Posted 29-Jan-17 12:42pm

BobbyStrain

Updated 29-Jan-17 16:01pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DanielBrownAU · Answer 1 · 2017-01-29T14:14:00

Solution 1

You need to setup the database and the application itself.

See MySQL :: MySQL Connector/Net Developer Guide :: 4.2 Tutorial: MySQL Connector/Net ASP.NET Membership and Role Provider[^]

Posted 29-Jan-17 14:14pm

DanielBrownAU

BobbyStrain · Answer 2 · 2017-01-29T16:01:00

I used that along with lots of others. But there seemed to be something missing from all of them. I finally found the right version number along with the public key for the type. After a few more changes I generated the tables, though some errors popped up. Then a few more changes finally got it working. I wonder if someone out there has all the proper instructions and web.config to get it to work the first time. Much of what I found was useless. But one posting had the answer close enough. The config information I posted is correct and it works. I'm not sure what finally got the problem resolved. Maybe the cold beer worked.

Thanks for your help. Now that I have the database created and can connect I will try to use it in another project. Now I will try to find a way to get the website admin tool to work in VS 2013! I am using VS 2010 where I encountered the MySql difficulties.