ASP.Net Membership & Roles Using MySQL- Basics Needed. - microsoft.public.dotnet.framework.aspnet

Message from discussion ASP.Net Membership & Roles Using MySQL- Basics Needed.
From: "Cowboy \(Gregory A. Beamer\)" <NoSpamMgbwo...@comcast.netNoSpamM>
References: <76228ffb-c313-4d0c-93dd-ef2e418ae627@q24g2000prf.googlegroups.com> <#yzt##1mIHA.3512@TK2MSFTNGP03.phx.gbl> <b0b6c960-2039-4685-a2b4-47a90ec759d1@24g2000hsh.googlegroups.com> <00e73621-bc2e-444e-ac19-31a5390e9af3@z24g2000prf.googlegroups.com>
Subject: Re: ASP.Net Membership & Roles Using MySQL- Basics Needed.
Date: Fri, 11 Apr 2008 09:19:11 -0500
Lines: 57
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
Message-ID: <e3n1E89mIHA.5280@TK2MSFTNGP02.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: c-98-193-193-3.hsd1.tn.comcast.net 98.193.193.3
Path: g2news1.google.com!news3.google.com!out03b.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!in03.usenetserver.com!news.usenetserver.com!newshub.sdsu.edu!msrtrans!TK2MSFTFEEDS02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP02.phx.gbl

First a google search yields:
http://www.codeproject.com/KB/database/mysqlmembershipprovider.aspx

This should solve most of your needs. It has both the scripts to create the 
database and the custom membership provider. This is an "out of box" 
implementation, meaning it mimics the standard ASP.NET implementation.

Note that the article states you need the latest MySQL Connector:
http://www.mysql.com/products/connector/net/

There is a cost if this is a commercial site.

If this is not acceptable, thsi one might work:
http://www.codeproject.com/KB/aspnet/Suite_MySQL_Provider.aspx

And the MySQL forum has one as well:
http://forums.mysql.com/read.php?38,63403,63403

-- 
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

*************************************************
| Think outside the box! 
|
*************************************************
"DanWeaver" <danofwea...@googlemail.com> wrote in message 
news:00e73621-bc2e-444e-ac19-31a5390e9af3@z24g2000prf.googlegroups.com...
> Later still and...
>
> I believe a few steps are necessary and Im not sure of the order or
> exactly how to go about them:
>
> A) Create the DB schema on a (shared host) MySQL db... Does anybody
> have the SQL already made?
>
> B) Set up the asp project to have a reference to the correct provider
> ie do something in web.config relating to <providers> and <connection
> string>...
>
> C) Change the ASP.NET Web Site Administration Tool to 'know' that
> we're now using a remote provider...
>
> D) Any other mystical steps involving importing namespaces etc...
>
> Any takers?
>
>
>