I was coding away on a new project that needed a membership back end. I usually use the built in .Net Membership Provider and make what ever changes I need on it. But this project requires a cost effective SQL solution so MS was out. MySQL has features for Membership Prover in .Net but it needs a little tweak to be setup. I found this great tutorial: http://dev.mysql.com/doc/refman/5.1/en/connector-net-tutorials-asp-roles.html
I only want to add one thing: when editing the machine.config file, right click the editor you are gone use and select "Run as administrator" or you will have a permissions error when you save!