Okay, so I'm cheating and not actually a question, but instead making a flat-out post. I know that goes against the grain of Stack Overflow, but this is too valuable not
to share. I'm assuming that you have Visual Studio Professional 2008 and access
to an instance of MySQL server. This MAY work with VS2008
Web edition, but not at all sure.
If you haven't, install MySQL Connector for .
NET (6.2.2.0 at the time of this write-up)
Optional: install MySQL GUI Tools
If you haven't, install MVC 2 RTM, or better yet, use Microsoft's
Web Platform Installer.
Create an empty MySQL database. If you don't want
to access your application with the MySQL root user account (insecure), create a user account and assign the appropriate privileges (outside the scope of this write-up).
Create a new MVC 2 application
in Visual Studio
In the MVC 2 app, reference MySql.
Web.dll. It will either be
in your GAC, or
in the folder that the MySQL Connector installer put it.
Modify the connection strings portion of your
web.config:
<connectionStrings>
<remove name="LocalMySqlServer"/>
<add name="MySqlMembershipConnection"
connectionString="Data Source=[MySql server host name];user id=[user];password=[password];database=[database name];" providerName="MySql.Data.MySqlClient"/>
</connectionStrings>
Modify the membership portion of your
web.config:
<membership defaultProvider="MySqlMembershipProvider">
<providers>
<clear/>
<add name="MySqlMembershipProvider"
type="MySql.
Web.Security.MySQLMembershipProvider, MySql.
Web, Version=6.2.2.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"
connectionStringName="MySqlMembershipConnection"
enablePasswordRetrieval="false"
enablePasswordReset="true"
requiresQuestionAndAnswer="false"
requiresUniqueEmail="true"
passwordFormat="Hashed"
maxInvalidPasswordAttempts="5"
minRequiredPasswordLength="6"
minRequiredNonalphanumericCharacters="0"
passwordAttemptWindow="10"
applicationName="/"
autogenerateschema="true"/>
</providers>
</membership>
Modify the role manager portion of your
web.config:
<roleManager enabled="true" defaultProvider="MySqlRoleProvider">
<providers>
<clear />
<add connectionStringName="MySqlMembershipConnection"
applicationName="/"
name="MySqlRoleProvider"
type="MySql.
Web.Security.MySQLRoleProvider, MySql.
Web, Version=6.2.2.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"
autogenerateschema="true"/>
</providers>
</roleManager>
Modify the profile portion of your
web.config:
<profile>
<providers>
<clear/>
<add type="MySql.
Web.Security.MySQLProfileProvider, MySql.
Web, Version=6.2.2.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"
name="MySqlProfileProvider"
applicationName="/"
connectionStringName="MySqlMembershipConnection"
autogenerateschema="true"/>
</providers>
</profile>
At this point, you ought
to be able
to run the app and have the default
ASP.
NET MVC 2 home page come up
in your browser. However, it may be a better idea
to first run the
ASP.
NET Web configuration Tool (in Visual Studio top menus: Project -
ASP.
NET Configuration). Once the tool launches, check out each of the tabs; no errors = all good.
The configuration tool Nathan Bridgewater's blog was essential
to getting this working. Kudos, Nathan. Look for the "Configuration Tool" heading half way down the page.
The public key token on the MySql.
web.dll that I've posted here ought not change any time soon. But
in case you suspect a bad token string from copying and pasting or whatever, just use the Visual Studio command line
to run: "sn -T [Path\to\your.dll]"
in order
to get the correct public key token.
There you have it,
ASP.
NET MVC 2 running over MySQL.
Cheers!
