MySQL is a popular database when it comes to web applications. It's easy to set up, easy to use, and supports many of the features you might need in your application.
Download MySQL Community Edition from http://dev.mysql.com/downloads/mysql/5.0.html#downloads. You can download only the Windows Essentials package to save some time (see FigureÂ 16). Download the file and then run the installer.
FigureÂ 16.Â MySQL download page
After the introductory screen, you'll be presented with some options. Choose the custom setup type. This will allow you to make some important choices about your setup later on.
You can choose to install MySQL anywhere on your system, but leave that option set to the default value for now. FigureÂ 17 shows the available program features you can select.
FigureÂ 17.Â MySQL Setup: Features and installation location
Once you click the Next button, you'll be asked to verify your setup and the program files will be copied. The copy will complete relatively quickly and then you'll need to set up the server.
You can safely skip the creation of a MySQL.com account.
Be sure the option Configure the MySQL Server Now is checked as shown in FigureÂ 18 and press Finish. This will run a configuration utility once setup completes.
FigureÂ 18.Â MySQL Setup: select the option ...