Install MySQL 5.0 on Windows Server 2003
1) To Install MYSQL 5.0 on a Windows Server 2003, you must first Download the MySQL Community Server file.
2) Once it has been downloaded, double-click on the file to start the installation.
3) Click “Next” on the MySQL Server 5.0 - Setup Wizard Window.
4) We will choose a “Typical” installation.
5) Click “Next” on the advertising for the Enterprise version, you can click on “More” if you want to have information about this version.
6) Click “Next” again on the second advertising for the Enterprise version.
7) The server is ready, but now it’s time to setup it. Check the box “Configure The MySQL Server Now”
8)Click “Next” on the First window of the Configuration Wizard.
9) Choose “Detailed Configuration” so we can tune the setup.
10) As long as the server will only be used as a MySQL Dedicated Server, choose “Dedicated MySQL Server Machine”.
11) Choose “Multifuntional Database” so it can be used for InnoDB and MyISAM engines (Difference between InnoDB and MySAM).
12) Choose on wich place you want to store the datafile.
13) I’m building a MySQL server for a website with a lot of connexions so I choose “Online Transaction Processing (OLTP)“.
14) As long it must be connected on a network, we must have TCP/IP, so check “Enable TCP/IP Networking“.
15) The server will manage english and french data so the “Standard Character Set” will be enough.
16) We’ll install it as a service so the server is starting when the server is booted and it will run in the background.
17) Enter the root (administrator) password, and check the box if you want to be able to acess the MySQL Server from an other machine.
18) Now to execute the setup click on “Execute“.
19) Wait while it’s finish, and click on the button “Finish” when it appears.
And the MySQL Server is installed and ready to receive data.
