Since My SQL has become the top data base server its good to learn how to configure it locally in your personal PC. That way you can test your data base driven web applications before uploading them to web sever. It could save you from lot of real big messes which could happen if you code didn’t work as you want. Installing My SQL 5 in Windows XP is not a hard thing. Also its lot easy than pervious  versions. You just have to follow steps and it would be installed no time.

First you have to install Apache and php in your pc before installing My Sql 5. If you haven’t done that yet, Now its time to do it.


Installing and configuring Apache web server in Windows XP
Installing php 5 in Windows XP

First, Goto www.mysql.com and download the ” MySQL 5.0 Community Server “. Unzip it and click on .exe file. and follow steps bellow.

Installing MYSQL 5 in windows XP

Installing MYSQL 5 in windows XP

————————————————————————

Installing MYSQL 5 in windows XP

Installing MYSQL 5 in windows XP

————————————————————————

Installing MYSQL 5 in windows XP

Installing MYSQL 5 in windows XP

————————————————————————

Installing MYSQL 5 in windows XP

Installing MYSQL 5 in windows XP

————————————————————————

mysql-05 Installing and configaring My SQL 5 with PHP

————————————————————————

mysql-06 Installing and configaring My SQL 5 with PHP

————————————————————————

mysql-07 Installing and configaring My SQL 5 with PHP

————————————————————————

mysql-08 Installing and configaring My SQL 5 with PHP

————————————————————————

mysql-09 Installing and configaring My SQL 5 with PHP

————————————————————————

mysql-10 Installing and configaring My SQL 5 with PHP

————————————————————————

mysql-11 Installing and configaring My SQL 5 with PHP

————————————————————————

mysql-12 Installing and configaring My SQL 5 with PHP

————————————————————————

mysql-13 Installing and configaring My SQL 5 with PHP

————————————————————————

mysql-14 Installing and configaring My SQL 5 with PHP

————————————————————————

mysql-15-a Installing and configaring My SQL 5 with PHP

————————————————————————
Setup a root user/password for database server. You can just use “root” for user and same for password too. It won’t matter since you would only use it in your local Machine.

mysql-16 Installing and configaring My SQL 5 with PHP

————————————————————————

mysql-17 Installing and configaring My SQL 5 with PHP

————————————————————————

That’s all. if you had done all correctly last screen will be link this.

mysql-18 Installing and configaring My SQL 5 with PHP

————————————————————————

Now you have to configure php with MySQL. For that open the php.ini file. ( C:\WINDOWS\php.ini ). and remove the ” ; ” which has in front of “extension=php_mysql.dll” as the screen print shown below. now restart Apcahe server.

mysql-19 Installing and configaring My SQL 5 with PHP

————————————————————————

To Manege data bases we use phpMyAdmin. first download the latest version from www.phpmyadmin.net and unzip it. Then rename the folder as “myadmin”. Copy this folder into your “web” folder. ( C:\web\ ).

mysql-20 Installing and configaring My SQL 5 with PHP

————————————————————————

Now open your web browser ( IE or Firefox ) and type this ” http://127.0.0.1/myadmin/ “. See whether you get screen below. If you get the message bellow , it means everything is all right and you only have to configure MySql user name and password with MyAdmin.

mysql-21 Installing and configaring My SQL 5 with PHP

————————————————————————

To change password to yours goto “libraries” folder in MYAdmin folder and open the file called ” config.default.php “. ( C:\web\myadmin\libraries\ ). There you have to find the place to insert root pssword. Use Find option to find ” ['Servers'][$i]['password'] =” “. and insert the password into space between quotation marks as screen shot shows.

mysql-22 Installing and configaring My SQL 5 with PHP

————————————————————————

Now goback to web browser and refresh the page when you got that message. Now page should look like this.

mysql-23 Installing and configaring My SQL 5 with PHP

————————————————————————

Thats all. Sorry You might feel some steps are too basic and really unnecessary but I want to make sure all steps covered so even a newbie can get installed it without a problem.