By Ziran Sun

The first part of this article illustrated how to install and configure the MySQL Database Server, install and use the MySQL Administrator, create a new database, and create and populate a new sample table with some sample data.

Now that the database server is up and running, this part of the article will complete our coverage of using MySQL with ASP.NET by covering how to:

• Add a new MySQL user.
• Assign the new user the appropriate permisions to the database.
• Connect to the MySQL server from .NET.
• Build a simple ASP.NET page to query the database.

more

By Ziran Sun

Introduction

Back in the days of classic ASP, if you were building a database-driven web site, your choice was either to invest a lot of money to get a copy of Microsoft SQL Server (or some other enterprise-ready database) or invest a lot of time finding a way to deal with the performance and scalability limitations of Microsoft Access. Luckily these days there’s another viable alternative: MySQL.

What is MySQL?

MySQL is an open source database server. While many organizations may choose to purchase a commercial version of the product, the GNU General Public License (commonly known as the “GPL”) ensures that the source code will remain available and therefore the software can be used free of charge for those willing to forego official support and support it themselves.

For more information, see the MySQL website.

more