Installing a MySQL Database Server Part 2

The first part of the  installation instructions are found at Part 1 of this article.

The first part of this article described the download and installation of the MySQL 5.1 Database Server on to a Windows computer. The following instructions continue the process by describing how to configure the MySQL database server (Version 5.1) once it has been installed on to a Windows computer:

1. The MySQL Server Instance Configuration Wizard will then start, click Next.
   
   
   
   
2. The MySQL Server Instance Configuration can be left set to "Detailed Configuration" then click Next.
   
   
   
   
3. THe default setting of Developer can be selected if you are using the MySQL server on your desktop machine for development and testing purposes. Then click Next.
   
   
   
   
4. The default setting of Multifunctional Database should also be used for development and testing purposes, then ckick Next.
   
   
   
   
5. The installation disk drive and path can be left to the defaults, then click Next.
   
   
   
   
6. The number of connections to the server has to be selected for development and testing the default setting can be used, click Next.
   
   
   
   
   
7. The default networking options can be used, click Next.
   
   
   
   
8. The default character set can be used, click Next.
   
   
   
   
9. The Windows options should both be selected, "Install As Windows Service" and "Include Bin Directory in Windows PATH", Click Next.
   
   
   
   
10. The "Modify Security Settings should be selected by default and you will need to entera "New root password" and then retype it to confirm the value, make a note of the password you have chosen as you will need it later to access the MySQL server. Then Click Next.
    
    
    
    
11. You have now reached the end of all the configuration options and you must click Execute to start the installation.
    
    
    
    At this point if everything has gone according to plan you should have the MySQL sever installed and working. If this is not the case you may need to Uninstall the server and try again or refer to the MySQL help information for Windows at http://dev.mysql.com/doc/refman/5.1/en/windows-installation.html

If you want to learn how to use MySQL we have a one day MySQL Database Fundamentals training course which is run privately as required.