Go to Google Groups Home    microsoft.public.dotnet.framework.aspnet
Re: ASP.Net Membership & Roles Using MySQL- Basics Needed.

Cowboy (Gregory A. Beamer) <nospammgbwo...@comcast.netnospamm>

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?