Installing MySQL on Windows XP

This tutorial will show you how to install MySQL 5.0.41 on machine running Windows XP.

To start with we will download all of the necessary applications which can be found at the following locations:

MySQL: MySQL download page

File to download: Windows (x86) ZIP/Setup.EXE

Create a folder on your desktop and place all downloaded files inside of it.

Now go the the C:\ drive and create a folder with a name webserver.
This will be the folder where all of our apache, php and mysql files will be kept. Inside of this create another folder: mysql.

Installing MySQL
Go to your desktop and inside the folder you have initially created find file mysql-5.0.41.win32.zip. Extract the content of this file to the same folder on the desktop. Now go inside mysql-5.0.41-win32 folder and double click Setup.exe. Follow the steps:

Fig. 18 - Click next.


Fig. 19 - Select Custom and click next.


Fig. 20 - Click Change button to change the path of the installation.


Fig. 21 - Navigate to C:\webserver\mysql and click OK, then click next.


Fig. 22 - Click Install to start installation.


Fig. 23 - During installation a new window will pop up introducing MySQL Enterprise. Simply click next twice to continue with your installation.


Fig. 24 - Your installation is finished. You are now ready to configure your MySQL Server. Click Finish to start configuration.

MySQL Configuration

Fig. 25 - On the first screen click next.


Fig. 26 - Select Detailed Configuration and click next.


Fig. 27 - Select Developer Machine and click next.


Fig. 28 - Select Multifunctional Database and click next.


Fig. 29 - Leave everything as default and click next.


Fig. 30 - Select Decision Support (DSS)/OLAP and click next.


Fig. 31 - Leave two options checked and port number as 3306 and click next.


Fig. 32 - Select Standard character Set and click next.


Fig. 33 - Select Include Bin Directory in Windows PATH and leave other options as default. Click next.


Fig. 34 - Tick Modify Security Settings and type in a password you want to use to access MySQL server, then click next.


Fig. 35 - Click Execute to apply configuration settings.


Fig. 36 - Click Finish to exit configuration wizard.

The last thing you need to do is to open php.ini file located in C:\webserver\php and uncomment the line extension=php_mysql.dll by removing semicolon ; at the beginning. Save the file and close it. Restart the computer.