Sorry if this reply is a bit late for you but I was looking to do the same thing and I just found out that the MySQL Membership and Role providers are built into the new MySQL.Web.Security classes of the 5.1.x versions of MySQLConnector/Net so you shouldn't need to build a custom provider now. It creates the database tables itself the first time ...

I recently started upgrading my projects to EntitySpaces 2007 and I have found that this version seems to make it more complicated to work with just one database. I work with only Sql Server in all of my projects. Prior to ES 2007, I only had to include the Sql Provider in my projects. Now, with ES 2007, all providers are pulled in by default. ...