ASP. NET + MySQL simple illustration

In the ASP era, if we want to build a database-driven web site, then you can choose a Microsoft SQL SERVER database with a lot of money or choose to spend a lot of time looking for an ACCESS database that achieves unified performance and stability, but in. in the NET era, you have another option: MySQL database
What is a MySQL database?
MySQL database is an open-source database that can be authorized to maintain official support for the source code and freely modify the source code. Currently, many companies and organizations use this database. For more information, visit the official site of MySQL.
Step 1 download and install
Like most software, the first is to get and install the mysql database software, obtain the Mysql database side is very simple, In the http://dev.mysql.com/downloads/index.html. this document uses Mysql4.1. Of course, you can download the pre-compiled binary file. However, we recommend that you download the pre-compiled binary file. My operating platform is Windwos XP, so I chose the Windows version that includes the installation file. This version is about 35 MB, so the download time is not very long, unless your network is faulty.
The installation process is very simple and does not cause any problems, such

In the last step of installation, the system will ask you if you want to configure the MySQL server. If you select to configure the MySQL server now, the system will automatically run the MySQL instance Configuration Wizard, so you will proceed to the next step.
Step 2 Configuration
The MySQL server instance Configuration Wizard makes it very easy to configure the server. Follow the Configuration Wizard step by step and select the default configuration most of the time.

For example, you can choose to install it on a dedicated database server or a shared server. Because of the laptop I use, I chose the simplest "Developer Machine ", this setting does not provide the same performance and does not support many system resources.

Make sure to respond to the TCP/IP network protocol to ensure that the Web server can connect to the database when the web page is required. If your database and Web server are installed on the same server, disable this option to prevent access from the network.

Step 3: MySQL Administrator