1. Create a new MySql database
2. Execute the Schema.sql file found in this App_Code directory - this will create all the tables
3. Open this solution with VS2008
4. Check the web.config file to do the following:

- ensure the connectionString is correct - ie. correct database name, IP, username, password

- check the applicationName used in the 3x MySqlProvider sections - default is "MyWebsite". You can change it if you like - I recommend you don't for the  test!

- in the MySql database, execute this command:
INSERT INTO `my_aspnet_Applications` VALUES ('1', 'MyWebsite', 'MySQL Profile provider');

- You are done !


You can: a) Run the ASP.NET web admin tool to add some roles
then you can b) Run the solution and from the website create a user / login / logout.


Just in case the urls are not automatic:

createuser.aspx
login.aspx
default.aspx  -  after login, this will display some data from the profile and role provider.




_____________________

Note: Why the INSERT above ?
It is important at the moment as the code still has a silly bug that it creates your application entry too late, so your first user will have an applicationId of 0 if the mysql table does not have an entry to match your applicationName. I can fix it, so could Mysql - but it takes time!

_____________________

Author: max@winsoft.hu
Any donations welcome! 
A copy of Microsoft Web Server 2008 would be fantastic :)

