Installation process

Table of Contents

3.1. MySQL Database Server 4.1.14

3.1.1. Downloading MySQL Database Server 4.1.14
3.1.2. Installing MySQL Database Server 4.1.14

3.2. MySQL Administrator 1.1

3.2.1. Downloading MySQL Administrator 1.1
3.2.2. Installing MySQL Administrator 1.1
3.2.3. Configuring MySQL Administrator 1.1

3.3. MySQL Connector/J 3.1.10

3.3.1. Downloading MySQL Connector/J 3.1.10
3.3.2. Installing MySQL Connector/J 3.1.10

Installation of MySQL involves installing three different components.

MySQL Database Server 4.1.14
MySQL Administrator 1.1
MySQL Connector/J

3.1. MySQL Database Server 4.1.14

3.1.1. Downloading MySQL Database Server 4.1.14
3.1.2. Installing MySQL Database Server 4.1.14

3.1.1. Downloading MySQL Database Server 4.1.14

Please visit this website: http://dev.mysql.com/downloads/mysql/4.1.html.

Scroll down the website that you just opened in your browser and locate the heading titled Windows downloads. You should see an entry titled Windows (x86) under this heading. Click on the link titled Pick a mirror corresponding to Windows (x86) as shown in Figure 3.1, “MySQL Database Server installation”, download the MySQL Database Server distribution and install it.

Figure 3.1. MySQL Database Server installation

3.1.2. Installing MySQL Database Server 4.1.14

The database server installation software is downloaded as a zip file. Extract the setup.exe file, execute it and perform the following steps.

You will be provided with three options: Typical, Custom and Complete. Choose Typical and Click Next.
Figure 3.2. MySQL Server 4.1 - Setup Wizard (Type of install)
Accept the default installation location and Click Install.
Figure 3.3. MySQL Server 4.1 - Setup Wizard (Default installation location)
Choose Skip Sign-up and Click Next.
Figure 3.4. MySQL Server 4.1 - Setup Wizard (Skip sign-up)
Make sure that the Configure the MySQL Server now option is checked and Click Finish.
Figure 3.5. MySQL Server 4.1 - Setup Wizard (Finish setup)
Choose Detailed Configuration and Click Next.
Figure 3.6. MySQL Server Instance Configuration Wizard (Detailed configuration)
Choose Developer Machine and Click Next.
Figure 3.7. MySQL Server Instance Configuration Wizard (Developer Machine)
Choose Multifunctional Database and Click Next.
Figure 3.8. MySQL Server Instance Configuration Wizard (Multifunctional Database)
Accept the default InnoDB Tablespace Settings and Click Next.
Figure 3.9. MySQL Server Instance Configuration Wizard (InnoDB Settings)
Choose Online Transaction Processing (OLTP) and click Next.
Figure 3.10. MySQL Server Instance Configuration Wizard (Online Transaction Processing)
Accept the defaults (Enable TCP/IP Netorking is checked and port number is 3306) and click Next.
Figure 3.11. MySQL Server Instance Configuration Wizard (TCP/IP Networking)
Accept the defaults (Standard Character Set is checked) and click Next.
Figure 3.12. MySQL Server Instance Configuration Wizard (Standard Character Set)
Accept the defaults (Install As Windows Service is checked, Service Name is MySQL and Launch the MySQL Server automatically is checked) and click Next.
Figure 3.13. MySQL Server Instance Configuration Wizard (Windows Service)
Accept the defaults (Modify Security Settings is checked) and use admin as the New root password. Also make sure that the Enable root access from remote machines is checked.
Please note that the screen below does not reflect the original screen. A text box has been added to show you that the new root password chosen is admin.
Figure 3.14. MySQL Server Instance Configuration Wizard (Root password)
Please note that the four circles on the screen are NOT check boxes. Click Execute to proceed.
Figure 3.15. MySQL Server Instance Configuration Wizard (Ready to execute)
Click Finish.
Figure 3.16. MySQL Server Instance Configuration Wizard (Finish and close)
Invoking the MySQL Command Line Client navigating to Start->Programs->MySQL->MySQL Server 4.1->MySQL Command Line Client. Enter the root password (admin and you should a screen similar to the one shown below.
Figure 3.17. MySQL Command Line Client

Please visit http://dev.mysql.com/doc/mysql/en/windows-troubleshooting.html if you get any error messages and type exit to terminate the Command Line Client.