While using MySQL connector/Net V6 and it's membership provider, the provider doesn't create tables it requires automaticly. After searching through internet, I got the solution. An extra attribute should be specified in order to create the schema automaticly.

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

The key here is the "autogenerateschema" attribute which is set to true. This indicates that the MySQL membership provider should create the database schema required. The database schema will be created next time you access the membership provider automaticly.

Hope it helps,