custom software design

ArticlesInstalling PHP 5.2.3, MySql 5.0, IIS 6.0 on Windows
custom software design

After hours of trying and re-trying and fustration, I finally installed PHP to work with MYSQL and IIS 6.0 Manager on a Windows XP machine. These are the steps I took. Hope that they work for you...

I installed PHP and MySQL on Windows XP platform with IIS 6.0. Please note if you are running IIS 5.0 Manager that comes with the Windows CD, the first thing I did was search google for "Download Microsoft IIS 6.0 Manager" and go to Microsoft to download and Install it. Once installed IIS 5.1 and IIS 6.0 manager will coexist in "Control Panel" -> "Administrative Tools".

(I have used IIS7 and have posted how I get PHP and IIS7 working together under part I of this article. Also reported that this article works on Windows 2003 Server Std)

Also download the following 3 items:
(Read Article Download Disclaimer First)
custom software design

* Download PHP 5.2.3 ZIP File (9.47 mb): Click Here to Download

* Download MySQL 5.0 (39.7 mb): Click Here to Download

* Download MySQL 5.0 GUI Tools (17.7 mb): MySql 5.0 GUI Tools (Tools to help you administer database)

Step 1: Configure IIS 6.0 to point to a local folder where your webfiles. Don't forget to create a file called "index.htm" (or index.html) add some HTML like a picture or fancy text font. Once you configure it, you should be able to see it by typing from the URL of Internet Explorer.

Step 2: Create a folder on C: called "PHP" and unzip the files from the PHP download into that folder. You should see a a bunch of DLL's and additional sub-folders called "ext", "extras" and "dev" with files in there as well.

Step 3: Open IIS6 Manager Right Click -> Default Website -> Properties -> Select Home Directory -> Select Configuration. On Application configuration check to see if .php is in list. If not click "Add". For executable browse to "c:\php" folder and select "php5isapi.dll". Click "OK" and then "OK" again. ** For IIS7, please see illustration below **

*** IIS6, PHP 5.2.3 - Click Here to See Visual Illustration on this Step ***

*** IIS7, PHP 5.2.3 - Click Here to See Visual Illustration on this Step ***

*** Extra 64bit Setting that needs to be changed for 64bit Machines ***

*** Windows 2003/2008 Server: Still getting 404 File Not Found Error ***

Step 4: Create a test file in the root of your web folder called "phptest.php" and insert the code below:

Step 5: In the "C:\PHP" folder copy the file "php.ini-recommended" to your C:\WINDOWS folder. Rename this file to "php.ini"

Step 6: Reboot the computer.

Once fully rebooted in the URL bar of IE, type "" and you should see it give you information about the PHP version.

If you see this then you know it worked properly and PHP is installed successfully!

Step 1: Install MySQL 5.0.

Step 2: Install MySQL 5.0 GUI Tools. These will allow you to view your databases and data structures

Step 3: Configure an Instance: The best way I configured it to work successfully was once it was installed to go into the "MySQL Server Instance Configuration Wizard" and click "Detailed Configuration", "Developer Machine", "Non-Transactional Database Only", "Decision Support (DSS)/OLAP", "Check Enable TCPIP Netwokring", Port 3306, "Standard Character Set", "Install as a Windows Service", Give it a main password that you remember like "root", Click "Execute!!".

*** Please note your username will be "root" and password will be whatever you typed (in this example "root"). After you hit "Execute", You should see 4 buttons light up with no red 'X's and you know MySql is configured correctly!

Step 4: Open the MySQL Administrator program. Set server host = localhost, username=root and password=root or whatever you set it to. Click on catalogs, if you see "mysql" then that is a main database.

This means that MySQL is installed properly!!

Step 1: In the C:\PHP folder copy the file "libmysql.dll" to your C:\WINDOWS\SYSTEM32 folder. Make sure you don't overwrite any existing file in this folder. If file exists, first rename it so you can go back.

Please Note: on 64bit OS Win7/8/etc..., you may need to copy "libmysql.dll" to the "C:\WINDOWS\SysWOW64" folder instead. for some reason SysWOW64 is the new SYSTEM32 folder.

*** Why IIS simply does not read the PHP directory? ...I do not know ***

Step 2: Edit this file "php.ini" that you copied to your C:\WINDOWS folder using a text editor like notepad. Find the line where it says "extension_dir = *something*". Uncomment this line by removing the preceding semi-colon. and set it to say: extension_dir="c:\php\ext"

Step 3: In the same file "php.ini" also un-comment out 2 other lines by removing semi-colon. Find the lines where it says: extension=php_mysql.dll and extension=php_mysqli.dll and uncomment both lines by removing the semi-colon.

Step 4: Reboot the computer

Step 5: I have provided a simple PHP script to test database connection to MYSQL. Copy and paste this into a file call it for example: "testmysql.php" and place it into the web root folder (same folder as "phptest.php")
Step 6: If you run this script by typing:
and it says "Successfully Connected to MySQL Database Manager!" and "Successfully Connected to Database 'MYSQL'" then this means that MySQL is now communicating with PHP and is installed and working properly!!!

Hope it helped!

Your Feedback
09/21/2018 - Your article made my day.only after I followed your suggestions, every thing connected properly - Polymath
10/14/2013 - thanks dude , you e awesome ! - Soe
07/23/2013 - sir as per your method i install php on my windows server 2003 its working properly php files are working properly but i am unable to connect mysql. - Pravin
04/17/2013 - So thankful for this post. I almost went crazy. - Sandi
12/22/2012 - thanks for your help - viranjani
09/28/2012 - After 4 days of trying, retrying, and frustration. I started to search IIS, PHP, MYSQL. And i tried your page to install and integrate all 3.And I found it was successful. thousands of thanks to YOU and YOUR team.Sanjay JhalaAhmedabad.INDIA. - SanjayJhala
08/22/2012 - Thanks for exelent and detailed instruction. - Matjaz, Croatia
08/02/2012 - This is a wonderful and freindly approach works on window server 2008 64 bit.php files are working without any error.Easy to install too.Thanks aLot once again.......... - Jack
05/15/2012 - Excellent and simple instructions Thanks bud, great help. - grace
04/23/2012 - such a supportive link, i realy appreciate and say thanks to team..... - Harish
03/22/2012 - This is good if everything works as planned. However, if we are stuck somewhere inbetween with an unexpected result, there is no indication of what it could be. I couldn get the php working when is used. But, if I use my host name, it works. I couldn get the MYSQL connection through php if I use the IP address or the host name. I have done everything instructed in this article. - Kish
02/20/2012 - Excellent! Appreciate you putting this up more than you know! - roberto
01/12/2012 - I am a C programmer with no experience with windows servers, PHP or MYSQL. Using this info I set this up in 2 hours. - Bruce
11/30/2011 - AWESOME! Many thanks, this was extremely helpful.One note, if you unzip the PHP files to a folder on the Desktop and then MOVE them to the destination directory (c:\php), the permissions will be wrong and PHP won work. I guess I should have followed your instructions more exactly!Thanks again. - Chris
11/07/2011 - Best work! Very helpful! Thank you very much! - vengadavaradan
11/03/2011 - Thank you very much man! You are GREAT! Other sites have been providing complicated approach.....I don need linux if i am to integrated my intranet with my database. - Micah
10/19/2011 - - pratap
09/23/2011 - It works! You e the man! - roby
09/08/2011 - Thank U so much!I spent lots of time trying to find out a solution for this issue on my own before I thankfully found this miracle. God bless you! - Miguel
08/26/2011 - hello thanks for all.i had done all above instruction.can you help me now i want to import my .sql(which i export from phpmyadmin) file into mysql database - nagesh
07/28/2011 - Thank You, thank You thank You.God bless you. - Brian
06/30/2011 - Its wonderful, run exactly with you write - Víctor
06/21/2011 - Great - the first thing that worked right here in Christchurch, New Zealand, after the recent earthquakes! - John
05/28/2011 - Fantastic! Very helpful! Thanks very much! - Patrick
05/20/2011 - Perfect!!! I used this on my Windows 2003 server after trying other examples I have seen and was very glad to see it worked the first time!!! - RDF
05/04/2011 - Thanks man. Its really good article. Anyway tell which is the best Php IDE? - Jaydeep
04/20/2011 - SIMPLYYYY GREAT MAN!!!!!!!!!!!!!!!1 - BHUSHAN
03/15/2011 - Thank You for giving such a wonderful help..... - Deepen
02/17/2011 - clearest article found on this subject, thanks. - Eddie
02/07/2011 - Thats perfect article, thank you so much!!! - wayne
01/12/2011 - Great work. very clearly explained. thank you for your great help - sandip
01/10/2011 - This was very very helpful - Cynthia
01/10/2011 - its very very nice. thanks very much - mahesh
12/20/2010 - Nice article.Really u did a great job!!Thank you. - SG
12/16/2010 - Thanks so much, I had been trying for days to get this to work! - BA
11/19/2010 - Oh man it just works fine !!! thanks a ton.. - Vicky
11/17/2010 - hi! man your post rocks! =D, this works with WinSvr2003Std too!!! thanks a lot!=D - jimmy
11/11/2010 - HiThis is very helpfulThanks - yogarajan
10/19/2010 - i was trying to install php mysql from last three days. Finally this post help me lot. Guide is simple and easier. Thanks for helping me... Zeeshan Sabir - zeeshan
08/10/2010 - This is an amazin article.. i culdnt have done without ths.. thnx yall r the best :) - Rebekah Leigh
08/03/2010 - You rock man. I could have never got it done without this artical. through the list one time everything worked Thanks for your time. - John
07/30/2010 - I am installing 1st time in my computer. Thanks for your valuable instruction. Thank you very much, i am so happy to install... - khaja
07/19/2010 - Thanks Man!!!! I have view many guides but yours is the best !!!!! Thanks!! - Bill
07/06/2010 - Dear friend i installed the IIS6, PHP and Mysql in my xp system after that i run testphp it work fine. After conf. mysql that page show only blank.can you please help me. I hope that you have the solution for that. Because you made every thing easy installationThank you - Rameswaran
06/25/2010 - I have done what your tutorial is saying but is not working for me. I install Mysql on drive C: with same with PHP folder. php is working but I still cannot integrate my PHP with mysql - Barnabas
06/11/2010 - Thanks for the help. - Kishore
05/25/2010 - Thanks very muchthis mexico...gracias buen articulo... - Marco
04/28/2010 - Thank you my work goes easier after i implemented this steps. Thanks a Lot.... - yuvaraj
04/26/2010 - I got a grate bridge to connect IIS, Mysql and PHP. A wonderful guide, thank you very mach - Dage
04/25/2010 - very nice. Thanks for the guidlines. It really helpfull. Thank you very much - Mark(Cebu-Philippines) - Mark
04/16/2010 - Thankssssssssss - Gaurav
04/11/2010 - After 4 days try to figure how works this example is the best i did to many things and work properly Thankyou so much - Juan
04/09/2010 - Unbelievable that 3 years after youve written this article, your simple copy libmysql.dll to windows\system32 command hasn been included in either MySQL, PHP, or WordPress install packages as a critical step (or the bug corrected).Cuz after days of searching and f*ing around to get things to work, that simple command did the trick. Thanks. - Eric
04/08/2010 - VEry helpful article. Thank you! - Gladisannajothi
03/13/2010 - Thanks very much for instructions. This worked with Server 2003, IIS6, PHP 5.3.2 and MySQL 5.1. - Mark
02/23/2010 - good one... this fix my 40 hour long issue with php mysql connectivity :-) Thanks Dude... - Sathyavrathan
02/09/2010 - Thanks bud, great help. - Kohen
01/24/2010 - I found it...And you really helping me...Thx a lot. - ofidz
01/22/2010 - Your Rock man ... - Bryn
01/04/2010 - Excellent and simple instructions. I wasted half a day trying to set up PHP with mySQL, to no avail, until, I stumbled onto this web page. It took me just a few minutes to set things up.Many thanks, - Don
12/23/2009 - Thanks for for your article ,It is the one best article to configure iis server with mysql - Arun
09/10/2009 - Oh man, oh man!But of course it works like a charm!!!!!!Fantastic!!!You've helped a lot, I mean it.Big thank you.Ryszard:) - Ryszard
09/01/2009 - Hi,Yes, the article is so nicely put together that even myself, a newbe, can understand most of its contents.Fantastic job!But, one thing I would kindly ask for assistance with is how to configure IIS 6.0 to point to a local folder where my webfiles are? Need more details, please?My best regards,Ryszard:) - Ryszard
08/03/2009 - SIMPLE PERFECTION!!!!!!!!! - fabio
07/21/2009 - Thanks a lot. Great article. I did an installation with no problems. - Miguel
06/24/2009 - Thanks a lot, easy to understand step by step tutorial. Works for me - Khiswar, Malaysia - Khiswar
05/28/2009 - Good Job. Excellent Post. Many peaple were having the same issue. I didntdo some of the steps which were mentioned in the article.Thanks....... - Vamshidhar
05/20/2009 - Hi Excellent notes very useful thanks - renganathan
04/08/2009 - Excellent work very very useful - sudha
04/08/2009 - I haven came across so simple steps to install php. HATS OFF dude :-) - Muralidhar
04/08/2009 - Your article helped me a lot. without it I would have to spend lots my time to configure PHP and MySql in Windows Server 2003. Everything is perfact just one thing is missing, I had to enable All Unknown ISAPI Extentions filter from my IIS so I have described that at my blog with your link. - Ritesh
04/01/2009 - Worked like a charm - thanks so much!!!!! - Robert
03/29/2009 - mi hermano soy de Venezuela se lo basico de ingles... y lo entendi todo... te botaste con este articulomuchas graciassaludos - ruben
03/29/2009 - Thank you so much, amazing tutorial, so easy, so simple.Tony from Mongolia. - Tony
03/17/2009 - Thank you very much for taking the time to make this article. It was a big help. - Justin
03/15/2009 - Thanks for Help - Amit
03/12/2009 - you have given all the information in very easy and understandable form as compared to other websites. good job and thanx for all these. - neeeraj
03/05/2009 - R/Sir or Madam I successfully install php and mysql and also configure mysql with php on windows machine Thanks for giving such information in a very much simple way. Now please tell me how i see the errors while doing php programming, if possible please tell me the solution on my given mail_id as mentioned above. Ashish Tupkar - Ashish
02/11/2009 - Thank you for this help document. It worked great, except one thing. I have already developed a site using Apache with PHP and MySQL and wasn required to use the ?PHP ? and could just use ? ? to open and close PHP. This is going to be a major issue unless someone can help me figure out how to fix this problem. Also, I can get my stylesheet to link correctly for some reason. If you or anyone, could help me with these issues Id appreciate it a - Warner
02/09/2009 - Excellent, one of the best technical articles on the web I have ever seen. THANK YOU! - Javad
01/30/2009 - Thanks - I tried all different ways - till I found this web site and took everything off my server and started from scratch - its working like a charm THANKS - Joe
01/28/2009 - Really nice article man!! thanks for help :) - priyatham
01/23/2009 - FRANKLY speaking I HAVE NO WORDS awesome n hats off.Warm RegardsSid - Sajid
01/06/2009 - You are a GodSend! I struggled with Apache to realize I had IIS on my system the entire time. Everything worked exactly how you said it would. You are awesome! - Jemeeka
12/30/2008 - Great great tutorial!!!! Thanks for your effort :) - Andreia
12/16/2008 - Another fine word to your help here. Really - gave me a push in the right direction... Thanks buddy. - Jay
12/13/2008 - Thank you very very much for your help especially for the first step of PHP configuration to work with MYSQL.I had done everything right before but it didn work until I do copy the file libmysql.dll to your C:\WINDOWS\SYSTEM32 folder.I really wonder *** Why IIS simply does not read the PHP directory? ...I do not know ***thank you again, life will be better with person like you .. - Ahmad
12/02/2008 - I want to thank you for the great work you did in explaining the steps to make this all happen. Thanks for the time you spent researching this to make mine and everyone elses lifes that much easier. Best guide I have read in a long time. Thanks again you are my HERO! - Forrest
11/28/2008 - You have saved my sanity!!!!!!!! thanks - James
11/24/2008 - I am deeply unhappy. I have spend 3 days trying to set up a test server for php on windows. I have not slept. I have not eaten. My wife has left me. Even my cats have dumped me. Then I read your article. I did exactly what you said. And do you know what happened??? You have absolutely ruined my life. And frankly you should be ashamed of yourself. It all works like a dream!!! I could give you a big hug. You are my hero.!!! Thank you my friend. Maximum respect Santini - GSD
11/06/2008 - Thank helped me a lot to configure everything.... - kshamata
11/01/2008 - very very very easy understandable :) I searched over the Internet for how to connect mysql to php but it was hard to understand specially for php beginners until I found this lovely site Thank you again :) - Mohammad
10/26/2008 - Let me congratulate you for keeping such important thing on your web site. I was trying to connect databases using php for more than 24 hours but got success only when I followed the guideline given by you step by step. Thanks for your immense intellectual help - santosh
10/17/2008 - Bless You !!!!!!!!!!!!!! Spent ages mucking about trying to get this to work. Works a treat now. Thanks again. Chrissy - Chrissy
10/08/2008 - All worked well except I get: Successfully Connected to MySQL Database Manager! Successfully Connected to Database 'MYSQL'! Error in my_thread_global_end(): 1 threads didn't exit I don't know if that is normal or not. - Steve
10/07/2008 - Great tutorial. I wish i would've seen this when i installed PHP & MySQL on my IIS server, unfortunately I had to learn the hard way. BTW, in case someone has trouble getting either PHP or MySQl to work remember to check the permissions on the folders that these are installed under. - johnnytsunami
10/03/2008 - Lovely article... after much of days hardword i luckily landed here at the end of the day.... and this article caught my eyes at first sentence... and finally everything seemed so easy... thanks alot :) Atksolutionss rockss.... who has written this article, his name is not given... but he is life saver :) Parag - Parag
09/29/2008 - THANK YOU! A couple of things other tutorials didn't mention: 1. Copying the "libmysql.dll" to the System32 directory 2. Uncommenting "extension=php_mysqli.dll" Not sure if it was one or both... but it's finally working for me! Thanks, again! - Jeff
09/22/2008 - Maravilha Brother, muito bom mesmo Valeu Obrigado Mesmo Thank You very much....... - Ademir
09/05/2008 - thx very much . it's good i'm thai - tin
08/31/2008 - el tutuorial estubo bien todo mesalio a la primera tal y como lo dice ai pero aora tengo un problema ... cuando entro a un formulario y guardo datos en la bd no se actualiza no pasa nada y se que mis codigos estan bien... y creo que el problema estan en las tablas poruqe si hay conexion con la base de datos pero de ai ya no puedo guardar los datos de ningun formulario ...porfavor ayundme a comoo componer esto . gracias por el tuto - peke85
08/31/2008 - Muito obrigado legal mesmo, procurei muito na net até encontra teu artigo e tudo funcionou perfeitamente Valeu!!!!!!!!!!! - Ademir
08/25/2008 - Thanks. This is good article. Helped me a lot to configure everything. - Prasad
08/24/2008 - It worked for me. It is really great for all who want to work with PHP and MySql. Before this i tried many times but never got it correct. Thank you very much. Manoj - Manoj Kumar
08/23/2008 - Nice and easy guide.Thank you!it's work perfectly! - Christopher
08/21/2008 - Why not just use WAMP? Google it, you can get your windows machine running a LAMP setup within a few minutes. Your way is what I tried first with no end of problem :P Thanks - Alan
08/21/2008 - It is worked for me. Thanks a lot - Firos
08/19/2008 - Thank You!!! This really got me out of a bind. It was straight forward and worked the FIRST TIME!!! I had spent hours trying to figure this out you have saved my project. - Robin
08/08/2008 - This guide is absolutely amazing! It also works perfect with IIS 5.1, MySQL-Front as GUI and the latest PHP package (5.2.6). - Kresten
08/02/2008 - Blank screen problem was self inflicted I incorrectly edited the php.ini file. Peter. - Peter
08/01/2008 - This install procedure works well for XP(SP3) thank you. When I use Zend IDE, IIS, PHP and MySQL the connections and pages all work, but when I load the page in I.E.7 dreaded blank screen? Any ideas? I see somebody else had the same problem. Best, Pete. - Peter
07/30/2008 - No Question, This is the perfect website to instal the Php and my mysql.with in one hour i make it working, Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!! - Brham Dev
07/15/2008 - Boss Tutorial helpd a lot.... - Arun
06/26/2008 - You don't have any idea how much I appreciate installation instruction. I have been searching many location to find such instruction that I can understand. Again, THANK YOU SO MUCH!!!!!!! - Mike
06/20/2008 - Thank you very much for your help. Your description is easy a clear to follow. I've been working on this for weeks and finnally found your site. Great it took me 30 minutes and everything is working perfectly. Nice job. - Michel
05/15/2008 - WOW!!!!!!!!!!! It worked gr8 for me........ Thanks a lot - Om
05/12/2008 - Hi... This installation instruction is very good... - Kirubaharan
05/07/2008 - really a very gud item for beginers as well as medium level programers to configure php & mysql with IIS webserver, I have tried it with IIS version 5.1. it work perfectly. thanks a lot man. you are rocking :-) - abhinav
05/01/2008 - Very Good Website & Thanks. Add some lines, how to configure 'Web Server Extension' for PHP in IIS Server. - C.P.Gupta
04/23/2008 - i did not have any problem with your instructions, it did flow like water, easy to understand, just on the money. Well done ! May God bless you and keep you! - Kabamba
04/20/2008 - thank a lot - skyleng
04/09/2008 - Thanks Friend, Thanks its working Fine, Greet Work......... - Prakash
04/06/2008 - Thanks a lot guy!! It really helpful for me. - Lukhwa
04/05/2008 - This is the best website for installing mysql. I recommend it to anyone who is having problem installing mysql. I followed the instructions and the install worked perfectly !!!! Greeting fom UK - Francis
03/28/2008 - This is the best website for installing mysql. I recommend it to anyone who is having problem installing mysql. I followed the instructions and the install worked perfectly. After 2 days of working to install mysql properly I found this site. Deleted everything I had and started from scratch. Downloaded software from this site and followed directions. I can now focus on the website application instead of installing software - Kelly
03/12/2008 - Awesome article!!! Thanks a lot! I used it with the latest PHP package(php-5.2.5-Win32) and it worked perfectly! Make sure you don't name virtual directory "*.com" (it won't work in IIS). Restart IIS after MySql installation before running testmysql.php. - Irina
03/11/2008 - Thanks a lot for this great walkthrough. I spend hours with scanning articles and trying different settings before i found this article on your website. Great work, very easy and finally it works. :o) - Mike - Mike
03/05/2008 - Excellent article. Thanks so much. Was reading's site to try and work out how to get MySQL to work without any luck. Your instructions worked perfectly. - Alison
03/04/2008 - Looked for weeks. Works like a champ! - Doug
03/03/2008 - Thanks man, I wasted almost an entire weekend on this, your steps worked perfectly! - Josh
02/20/2008 - Thank you for the great tutorial! - Boaz
02/18/2008 - ur all information very usefull .it help me alot.but i want to know that how configure all these on win 2000 and 2003.may be there some other things which u not mension here. - anju
02/12/2008 - What a lifesaver. By far the best tutorial about getting mysql to play nice with php. Thanks you - hellsyeahHNB
02/05/2008 - You have done great work. Keep it up. But i have one issue that is drving me nut. I can create database/table using MySQL and can execute it using the php in the browser, but I cann't add/delete data into/from the MySQL databe using the PHP browser. Any hint! - C
02/02/2008 - Thank you, thank you!!! It finally worked! At first i thought there was something wrong with my installation, but when i highlighted Default Web Site in IIS, i noticed that phptest.php was named phptest.php.txt... darn! Anyway, great job at this tut. Much appreciated! - Alex
01/28/2008 - Thanks. This got it working. Clearly set out. Danny Crossley. - Danny
01/25/2008 - Hi, You have done a very good job.. its helpful for me.. thanks a lot - Nidhi
01/23/2008 - Have one issue that i am working through and any help you might be able to offer would be greatly appreciated. From the CLI the database connection works great, but from a webbrowser it wont connect and throws a cant create tcpip socket(5) - Nate
01/18/2008 - Great Work,Very systematic & very helpful.Come up with php on linux Good job - Sanjeev
01/17/2008 - Perfect. After 2 days of pulling hair out, these instructions work perfect!! Thanks - Dave
01/16/2008 - You are the best - El
01/15/2008 - Amazingly clear and accurate where all others leave you dazed and confused. Thank you, thank you, thank you!!! - chadd
01/07/2008 - Just tested this install on W2K3 server with IIS 6.0/PHP/MySQl and the new FastCGI.. works KICKASS. Minor tweaks with the .dll file for FastCGI.dll's instead of the ISAPI.dll's. Love it! Your MYSQL test is simple and effective. I found this site because I couldn't figure out if MySql was functioning correctly. YOU ROCK! Thank you. If you ever need any Porsche work.. let me know :) - BradR
01/05/2008 - Thank you for your article on this,very clear and easy to follow. I normally can not get my head around most instructions that are written on the net, I would be here for days if it were not for people like yourself. I see I am not the first to praise your efforts and I doubt I will be the last. - Jason
01/03/2008 - THANKS!!!!! the extension_dir setting wasnt set properly for me and I didnt see that in any other post.! You saved the day! - Jon
12/27/2007 - I spent nearly a week to make the three; php, mysql and iis work together but with no luck. If php and iis worked then mysql would create problem.but your tutorial managed to harness the three together in less then an hour.Thank you ...........thank you and thankyou again and again. rajvir - rajvir
12/27/2007 - i install php an my sql as ur stepa.i also write script for the connection.there is not any error ther but it is not display anything on my ie.and i install xp sp-1 with iis6.0 - niral
12/11/2007 - Great article. It's always the shocking looking sites that have the useful stuff. Well done. - Steve
12/06/2007 - Wow. You just answered all my questions on how to get php and mysql working on XP. Your directions were flawless... works perfectly. I must have spent 6 hours screwing around helplessly on this until I came across your step-by-step instructions. Now if I can only get ImageMagick working on it too! Thanks a million!! - Mark
12/04/2007 - Great article but I have an issue still. All steps work fine, PHP install, MySQL install, reboot the server but when I try to load the page in IE7 on server 2003 it simply loads a blank page, no 404 just blank.! I know IIS can read PHP as the php test file is good? Any ideas? - GB
11/26/2007 - Yet another happy person. Thanks so much for putting this article together! I wish I had found it at the beginning of my install journey. - Donnetta
11/23/2007 - Excellent article. Its save my lot of time. I was implemented wordpress blog using IIS 6.0 in windows server 2003 enterprise edition. Its run without error. Thanks once again. - Manoj
11/21/2007 - Thanks a lot, this article was very helpful to me. the important thing in this article is that it is very clear and precise to understand Thanks again Regards, Mansoor Ali - Mansoor
11/21/2007 - THANKS! This saved me a lifetime. It's good to see a complete helpful install doc. - Andrew
11/19/2007 - Thank alot.. You are the best. I have tried so many places to find info to get the things to work. Your had no flaws. So straight forward and no errors.. I would recommend everyone to follow this instructions.. Thanks a mil. - Tito
11/19/2007 - thanks, like most people on here i've been pulling my hair out trying to configure php and mysql. 10 mins on this site has done what 5-6 hours on other sites couldn't. Thanks - Peter
11/17/2007 - OH MY GOD!!!!!I have spent over a week going to like a million pages looking for help on this. Some places told me how to do all this crap and nothing happened, then I came to you and it was like 3 steps and BAM it works now. Thanks alot. P.S. Most of those sites I went to was microsoft and IIS websites, They know nothing!! - Michael
11/12/2007 - Good on ya mate!!! thanks a ton - kunal
11/09/2007 - Absolutely Outstanding!!!! In less than 30 minutes, solved the installation, that I've have spent about ten hours on. Actually, I don't think I could have solved it without your instructions. The placement of the php.ini file in the windows directory and libmysql.dll in the system32 directory were KEY aspects of getting this to work. Previously, changing the path environment variables did not work . . . Anyway, thanks for taking the time to do this. It is very much appreciated. - Rick
11/08/2007 - hello there!! this article really helps me,except to the last part when configuring php to work with mysql i believe i follow all the instructions but when i run the page it says that. Unable to connect to database manager. Could not connect: Access denied for user 'root'@'localhost' (using password: YES) can anyone please tell me what went wrong and how to fix it.. - Erwin
11/03/2007 - Thanks, I was tearing my hair out trying to get them all installed and working on my laptop last night. A clear head this afternoon and a read-through of your article solved all my problems :) - dpmcalister
10/29/2007 - Amazing tutorial, I recommend this to anyone who what to host webpage using PHP. This is totally fool proof!!!! Thanks Ben - Benoy
10/26/2007 - Great instructions,keep up the good work! - tony
10/17/2007 - wow It help me a lot....Thank u v much! - vish
10/16/2007 - I was struggling with this issue for many days. Thanks to the author i found this. It helped me a lot. Great appreciation to this article. - Bulsa
10/12/2007 - This works even if you already have PHP and just want to set up MySQL w/IIS6. Thank you for taking the guess work out of it and saving me a lot of valuable time on my new programming hobby. - Adam M.
10/12/2007 - Hi Thanks for the article. Really good. But one problem, include() is not working , just the php code is getting printed. plz help - kathy
10/10/2007 - Wow! Thanks so much. So much frustration followed by a huge sigh of relief. Thanks for your help! - Greg
10/08/2007 - this is a very nice straightforward documentation. But I am still unable to connect to mysql!! I have of all the steps with no luck. - mowali
10/05/2007 - Thanks. Very good article. - Sharky
10/04/2007 - I wish I had found your article before I started! Thank you very much for your help! - Dan
10/02/2007 - Awesome article dude .. really solved my problem ... U Rock .. Keep the great work going .. - ritesh
10/02/2007 - Unbelieveable after days of stuggling it actually works. It took me less than 20 mins to go through your instructions. I cannot thankyou enough for your comprehensive instructions!! Wish everyone could make things this easy - Kate
09/28/2007 - Cool - thanx for your contribution... did a lot of researching to resolve the connection issue until I tripped over your very pragmatic solution. There is a classic way to resolve the issue: include the path tp your php directory in windows environment variables - path. Nevertheless your hint is gold worth! - Andreas
09/27/2007 - Wonderful!! Clear and easy to follow!! - p
09/20/2007 - Thank you for the great write up. I was missing libmysql.dll which was causing my issue. FYI, if needed, if php.ini is not loading changes, to force a reload WITHOUT REBOOTING, kill w3pp.exe and let it fire back up. You may need to stop/start iis afterwards. - Matt
09/17/2007 - I tried this on IIS5.0 running on Windows 2000 server and it worked perfectly. Thanks. - Lito
09/15/2007 - hi, thanks a lot and please help me ... i have installed every thing perfecly php,mysql,and IIS6 your all examples are working fine. but when i host my web site. only the main page is showing properly and all other pages are not viewing properly ... in IE6 and IE7 and mozilla firefox also. is there any thing to do in the configuration.flash is wokring fine. - Raghunath
09/14/2007 - So all I get is this tiny window? Oh, well. After many fruitless efforts, I finally got PHP snd MySQL installed, thanks to your very clear directions. A few points: 1) Why can't other software vendors write straightforward directions like this? 2) If, like I did, you already installed MySQL at some point, your attempt to remove it and reinstall it is not going to go as smoothly as described, because the removal procedure does not remove the original password; after removing MySQL through the normal Windows "remove programs" function, you should delete the entire "C:\Program Files\MySQL" folder, in order to remove the old password; 3) you may need to edit the C:\Windows\php.ini file that this procedure generates. - Pink
09/13/2007 - for several days i have been tring to get connection to database through php. you have given simply way. Thank you .......... thank you..... thankyou verymuch - Surya
09/11/2007 - thas was the best easy way to install it ever I saw. I tried couple of other instruction, but none of them was as easy as this one. - Ali
09/06/2007 - This was exactly what I needed - clear and concise. Thank you. - Andrew
09/05/2007 - Your info is very good, I'm going to use it for a MySql Installation in my Desktop and to make some test on it!! Thx a lot!! Greetings - KlimUser
09/04/2007 - Hi, Just wondering why didnt you use IIS 5.1? Regards Alvin - Alvin
08/31/2007 - Thanks for the guidlines. It really helpfull. I was able to do it at one go. Thank you verymuch - tulika
08/30/2007 - your php and mysql configuration is very helpful. Thank you for sharing the information. - daylan
08/24/2007 - Hi, your article on how to install php and mysql was very helpfull. I tried to install it on windows server 2003 r2. Many attempt but I just didnt got it to work. I read your article, followed your steps and it worked right away! Thanks! Greetings Rien - Rien
08/24/2007 - Wonderful!!!!!!!!!!!!! - Debbie
08/23/2007 - You rock! Thank you very much. This was very helpful! - pwyon
08/21/2007 - This is the first article that really help me to create a connection to Mysql. Thank for help. Walker Rivas - Walker
08/10/2007 - This dokumentation has really really helped me, after i failed with 3 other dokumentations... and now it works!!! thank you very much - Joe
08/09/2007 - Thanks for helping me installing php5.2.3. and mysql.5.0 but I have one problem. All goes perfect with one exeption: my browser does not shoe my the error in case a write a incorrect php script. What should I do? Thanks! - Dinu
08/08/2007 - what is the default username and password for ""? - Jermen
08/01/2007 - Thank your manual this was very useful and saved the last few remaining hairs on my head. Very usefule and easy to follow instructions. Cheeers - Nasser
07/26/2007 - thanksssssssssssssssssssss - ali
07/23/2007 - It just won't work for me and I feel I have done everything right. PHP worked once, the I tried to add MySQL and the whole thing just stopped working and I can't get it back now. Tried re-installing PHP 5.2.3 three times and no luck. There are so many settings in the php.ini file that I don't know what to do with. Help? - Andrea
07/22/2007 - Great article. Jump started my PHP installation. I was getting nowhere before reading your article. However, in my case, I found that registery setting is necessary. I have to edit and run the pws-php5isapi.reg to make my installation work. I thought someone might have the same experience as me and looking for a solution and would like to help them just like you helped me : ) Cheers, Ramins - Ramins
07/10/2007 - I need to download - only IIS 6 , or IIS 7... thnx... - Arton
07/08/2007 - Wow this is superb but hey the php is unable to recognize mysql do tell me a way out Andy - Anand
07/07/2007 - I have tried MySQL with Kevin Yank(sitepoint) guide, but failed. At the same time your article helped me succeed at first try. Thank you very much. - G.
07/06/2007 - very nice article but I get the error undefined call to mysql_connect() - anand
06/28/2007 - THis article was perfect man thanks a bunch ive been trying to setup this thing for a week without success and your way got it done in 10. Kudos to you - Sadiki
06/27/2007 - Excellent tutorial! a life saver! - Fionnuala
06/27/2007 - Thanks alot! Works like a charm! - Robert
06/19/2007 - Thanks much. I had determined everything except copying the libmysql.dll to windows/system32 and had been pulling my hair out till I found your page. Thanks again. - chris