IIS Admin Blog

There are currently 65 responses to “How To Install MySQL and PHP on IIS 6.0”

Why not let us know what you think by adding your own comment! Your opinion is as valid as anyone elses, so come on... let us know what you think.

1. 1 On September 19th, 2007, Daniel Gutierrez said:

   Thx for this too!!

2. 2 On September 19th, 2007, Daniel Gutierrez said:

   just don’t copy -paste the commands because of the ‘ character

3. 3 On September 25th, 2007, Elyinn N. Somarriba said:

   I cant get the MySQL module up, and i have check the extensions.

   HTTP Error 401.5 - Unauthorized: Authorization failed by an ISAPI/CGI application.
   Internet Information Services (IIS)

4. 4 On September 26th, 2007, Paddy H said:

   Fantastic - after a bit of tweaking it works
   Any chance of a PHPMyAdmin tutorial on IIS6 as I cant get that to work?

   Great Job!!

5. 5 On September 26th, 2007, Paul Lynch said:

   Hi Paddy,

   Thanks for your comments. The PHPMyAdmin tutorial is on its way.

   Paul Lynch

6. 6 On October 15th, 2007, Mark Sellars said:

   Hi, followed tutorials as complete newbie at this. Having a problem though - can anyone help. All php installed to c:\PHP - if i set the path & phprc under environmental variables to c:\php\ then i get the correct result with the dbtest.php file. But the test.php file does not work - i get a blank page.

   If i change path & phprc to c:\program files\php\ then restart IIS then try dbtest.php it does not work i get error: Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\wwwroot\dbtest.php on line 3

   test.php works - BUIT i do not get the new section for MySQL or ZIP after allowing those.

   Please help in simple talk please. Thx

7. 7 On October 16th, 2007, Paul Lynch said:

   Mark,

   If the dbtest.php file in the article works (i.e you connect to MySQL but cannot access any of the databases) then you have got everything setup correctly. If you change your PHPRC variable to point to a location where no valid php.ini file can be found then the extensions you have enabled (mysql, mysqli, etc) won’t get loaded and therefore MySQL connectivity will fail.

   I’d suggest removing any previous PHP installations (which it looks like you may have on your machine) and starting again from scratch.

   Paul Lynch

8. 8 On October 24th, 2007, kazex said:

   PHP working fine
   I add 3 dynamics extension to php.ini and i restart IIS
   when i run index.php (test) i do not see any MySQL support

   when i run dbtest.php
   I see :

   Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\OSCgt\dbtest.php on line 3

   what is going on ?

9. 9 On October 25th, 2007, Paul Lynch said:

   Kazex,

   Did you follow the steps *exactly* as shown in both of the articles ? It might be worth going back and starting from scratch if you didn’t.

   It could be that you haven’t enabled the correct extensions or that you have got MySQL in your system’s PATH *before* PHP - this can cause PHP to try and load the first version of libmysql.dll that it finds - if it uses the version of libmysql.dll that ships with MySQL this can cause problems.

   Paul Lynch

10. 10 On October 25th, 2007, kazex said:

    Hello again !

    Ok MySQL work on localhost, how to set the server MySQL on specified IP ?

    I have two nic cards on server -> one for internet from DSL , and two for LAN, how to set MySQL to work on static IP from DSL ?

    kazex

11. 11 On October 26th, 2007, kazex said:

    OK wrong question.
    For now doesn’t work connection between PHP and MySQL.

12. 12 On November 1st, 2007, KW said:

    I’m still getting errors on setting up phpMyAdmin. I’m able to get it to come up, but there is the following error message at the bottom of the control panel:

    “Your PHP MySQL library version 5.0.45 differs from your MySQL server version 3.23.32″

    The following is the versions of PHP and MySQL that I installed on a Windows Server 2003 running IIS 6.0:

    MySQL: 5.0.27
    PHP: 5.2.4
    phpMyAdmin 2.11.1.2

13. 13 On November 2nd, 2007, Paul Lynch said:

    KW,

    Try renaming your libmysql.dll file in your PHP folder to libmysql.dll.bak and copy the libmysql.dll file over from the MySQL bin folder in its place.

    Alternatively, make sure that your PHP folder appears in your system’s PATH *before* your MySQL folder.

    Paul Lynch

14. 14 On November 7th, 2007, David said:

    Wonderful site!

15. 15 On November 9th, 2007, Erick said:

    Most helpful! Is it possible to get a step by step guide for phpMyAdmin?

16. 16 On November 14th, 2007, Kyle said:

    These were great tutorials. I followed the PHP and the MySql setups and have gotten them setup. I am a noob when it comes to these but have gotten this setup with ease from the tutorials. Thank you

17. 17 On November 15th, 2007, Mark said:

    Fantastic tutorial. Very easy to follow. I had my website up and running in a couple of hours. Thank you

18. 18 On December 8th, 2007, Lumby said:

    Hi great site ;o)

    I can not get my test.php to show mySql i’m using mySql 5.0.45 and php 5.2.5

    mySql is working but I can’t connect from a php script.

    I hope you can help me!

19. 19 On December 10th, 2007, Richard said:

    I kept on getting “Call to undefined function mysql_connect()” and then I copied the php.ini file to c:\windows and it now works.

20. 20 On December 13th, 2007, Sarah said:

    Your tutorials ARE AWESOME. I only wished I had found them before I tried several different tutorials that I feel messed up quite a few things.

    ANYHOW - I got your message about PHP this morning and that is now understood as functioning 100%. My next dilemma is that I followed your mySQL step by step and I get the MySQL in the test we ran for PHP but when I pull the dbtest.php I get a username/password prompt…nothing will work on it then I get a 401.1 error, unauthorized: access is denied due to invalid credentials.

    I am hoping a tutorial I followed before did not mess anything up - hopefully you can point me in the right direction to solve this one?!?!?

21. 21 On December 17th, 2007, Sarah said:

    Has anybody had the problem where trying to access the dbtest.php on a live website prompts a username/password and won’t allow viewing of the website???

22. 22 On December 17th, 2007, Paul Lynch said:

    @Sarah,

    What status code do you see in your browser ? Does a test phpinfo page work with the same credentials ?

    Paul Lynch

23. 23 On December 18th, 2007, Sarah said:

    I get a 401.1 error, unauthorized: access is denied due to invalid credentials. If I test the phpinfo.php page everything is fine! That’s what is bizarre

24. 24 On December 18th, 2007, Sarah said:

    Paul,

    I just clicked again and got a different error, so basically if I enter in the database username and password I get the 401.1 or if I don’t provide it and just try to skip the prompt I get this:

    HTTP Error 401.5 - Unauthorized: Authorization failed by an ISAPI/CGI application. Internet Information Services (IIS)

25. 25 On December 19th, 2007, Peter cspw said:

    KW, Paul Lynch - re error
    Your PHP MySQL library version xxx differs from MySQL server version 3.23.32.

    I followed Paul’s advice to no avail. Here is how I got it fixed: The problem was that I had set up (via the phpmyadmin/setup.php script) for a control user and a control database, but the pma user and the corresponding database had not yet been created. Once I created them (by using phpmyadmin to add the new user pma, and then importing the scripts/create_tables_mysql_4_1_2+.sql to create the database and its tables), the issue disappeared.

    I noticed on the phpmyadmin home page that before I’d created the control database the first line was ‘Server version: 3.23.32′ (wrong), but after I’d created the pma user and the control database I magically got ‘Server version: 5.0.45-community-nt’, and the error went away.

26. 26 On December 22nd, 2007, Paul Lynch said:

    @Sarah,

    Check to see whether your IIS_WPG group and your anonymous user account (IUSR_MACHINENAME) have got Read permission over both your PHP and MySQL folders. You could also try using Filemon from Sysinternals to try and flush out any permissions issues :

    http://www.microsoft.com/technet/sysinternals/ProcessesAndThreads/Filemon.mspx

    Paul Lynch

27. 27 On December 26th, 2007, Madhu said:

    Copy the php.ini file into windows/system32 dir then, you can possibly run dbtest.php file.

    its should works according to the instructions..

    Rgds,
    Mylaimadhu

28. 28 On December 29th, 2007, mrCharger said:

    Thanks a lot for your excellent guides!

    You have really helped me a lot.

    Keep up the good work!

    //Thomas

29. 29 On December 31st, 2007, pjsdad said:

    trying to set up a dev server at home. have run through the processes several times (both with and without the installer). at this point, I can get the phpinfo from both the web root and the specific site root. However, when I try to run through the site I have put together, the scripts cannot see the dll’s for mysql (even though they are in the correct places, as are the dependencies as well.)
    I’m in critcal mode here, as I need to make some changes before posting code to a production server.

30. 30 On December 31st, 2007, Paul Lynch said:

    @pjsdad,

    Try renaming your libmysql.dll file in your PHP folder to libmysql.dll.bak and copy the libmysql.dll file over from the MySQL bin folder in its place.

    Alternatively, make sure that your PHP folder appears in your system’s PATH *before* your MySQL folder.

    For example, my system’s PATH looks like this :

    C:\>path
    PATH=C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\
    Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\
    PHP;C:\MySQL\bin

    Paul Lynch

31. 31 On January 2nd, 2008, David Tudor-Cole said:

    phpMyAdmin Tutorial please

    Monday 7th and a lot are back at work with a vengeance so would really like to move MySQL database to a new Server before then - and phpMyAdmin is the bees knees for doing that task.

    Sending you a bucket of virtual sunshine from New Zealand to brighten your day and put you in the mood for blogging

    Dave

32. 32 On January 2nd, 2008, David Tudor-Cole said:

    Came across this in my emails which may or may not be relevant in this series:

    From: Brett Hill iis6 Discussion

    Have you tried using FASTCGI for IIS 6? It may be more stable and better performing. In terms of IIS / PHP integration, FASTCGI incorporates lessons learned by Microsoft working with Zend. The PHP ISAPI can have problems due to thread safety that results in unpredicatable and unavoidable crashes. FASTCGI was created to avoid this. This could what is causing your recycling and the resulting need for web gardens resulting in your need for out of process state persistence.
    http://www.iis-aid.com/articles/my_word/difference_between_php_thread_safe_and_non_thread_safe_binaries

    BTW, ASP.net has had state persistance built in for a long time, it’s just not the default since in many cases it is not required for apps. http://support.microsoft.com/kb/307598 .

    Paul - Your comments appreciated.

33. 33 On January 7th, 2008, Morris said:

    Hello,
    I installed using v5.2.5. To get it to work, I needed to remove the libmysql from mysql and mysql\bin and move php.ini to windows directory. Using phptest, I get errors, using root, blank screen.
    Thank the Good Lord someone smarter than me will be taking care of this when in production!
    Best,
    Morris
    http://www.spaseeba.com

34. 34 On January 11th, 2008, Daniel Goepfrich said:

    Hello,
    I’ve read and re-read all of the instructions and comments for this, but I still keep getting this error:

    Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\Www_root\php_website\dbtest.php on line 3

    Everything else shows exactly as you have said it should. I’m running PHP 5.2.5 and MySQL 5.0.45.

    What am I missing here? Thanks

    Daniel

35. 35 On January 11th, 2008, Daniel Goepfrich said:

    OK, never mind, I guess. After sitting a while, now it works. I tried it several times before, but, OK. Thanks

    Daniel

36. 36 On January 11th, 2008, riyaz said:

    Hi great site ;o)

    I can not get my test.php to show mySql i’m using mySql 5.0.45 and php 5.2.5

    mySql is working but I can’t connect from a php script.

    I hope you can help me!

37. 37 On February 18th, 2008, alex said:

    php and IIS work together but mysql - as soon as I add any mysql command I got “blank page”.

    mysql runs as a server and I can connect to the database as root - fine; I used root in dbtest instead of phptest just in case - same result.
    I copied mysqlib.dll from mysql to php.
    Any idea would appreciated

38. 38 On February 21st, 2008, PaddyH said:

    I get the same result….. however make sure when you do the phpinfo(); the make sure the PHP.ini file is in the right place

    This fixed it for me

39. 39 On February 21st, 2008, PaddyH said:

    ……………..and any changes youmake to the PHPRC value, php.ini or the my.ini always do a windows reboot!

40. 40 On February 26th, 2008, Dave said:

    where is the section on phpMyAdmin?

41. 41 On February 27th, 2008, Paul Lynch said:

    @Dave,

    Its on its way. Its been a busy time for me lately and I’ve not had much free time to work on blog posts.

    Paul Lynch

42. 42 On April 26th, 2008, Adam said:

    This sucks, I followed your article all the way through and I really like the details, I got stuck while attaching php to mysql. Mysql session doesn’t show up on the index.php

43. 43 On April 28th, 2008, Paintworkz Web Design said:

    I finally managed to get all this working, but have strange problems with mysql. My php developer can get our application to run fine on a LAMP install, but when installed on windows iis6, we keep getting problems with the database install. PHP on iis is fine.

44. 44 On May 13th, 2008, Bernie said:

    I have PHP working and am trying to configure MySQL, but I cannot get the Security Settings to work (it asks for my previous password, which I cannot remember).

    I get the error no. 1045
    Access denied for user ‘root’@'localhost’ (using password: YES)

45. 45 On May 29th, 2008, Sean said:

    I have PHP and MySQL installed, but MySQL is not working. In the PATH variable, PHP is before MySQL. I followed your instructions by the letter, but it keeps coming up with “undefined function mysql_connect()”.

    Any ideas?

46. 46 On June 10th, 2008, David said:

    For those of you getting the blank page problem, in my case there was a copy of libmysql.dll in the system32 directory which was causing the problem. This may have been corrected if c:\php was the first part of the path so I suggest you search for all copies of the file and rename them all save for the one in c:\php.

47. 47 On June 12th, 2008, koushika said:

    please help me when i browse the http://localhost/index.php file we created in the first article i cant see support for MySQL

48. 48 On July 24th, 2008, Patrick said:

    Thanks, Paul, for the great tutorials. I was able to complete the PHP tutorial without a problem. MySQL has gone well, too, up until this point. I’m checking the dynamic extensions in my php.ini file and can’t get my index.php page to recognize MySQL. Here’s a snippet of what the php.ini file looks like:

    ; Windows Extensions
    ; Note that ODBC support is built in, so no dll is needed for it.
    ; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
    ; extension folders as well as the separate PECL DLL download (PHP 5).
    ; Be sure to appropriately set the extension_dir directive.

    extension=php_mbstring.dll
    extension=php_mysql.dll
    extension=php_mysqli.dll
    ;extension=php_bz2.dll
    ;extension=php_curl.dll

    The extensions you list in your tutorial have been moved to the top of the list with the semi-colins removed. I’ve done iisresets and reboots, but still can’t get the index page to display the MySql info. FYI, I did not move my php.ini file to the ‘inifile’ directory. It is still in c:\php.

    Thanks for any help in advance.

49. 49 On July 30th, 2008, Paul Lynch said:

    Patrick,

    See if this helps :
    http://www.iisadmin.co.uk/?p=4#comment-40

    Paul Lynch

50. 50 On November 21st, 2008, Raul Rosa said:

    Great instructions…

    I am not able to get the test account created on MySQL.
    I login with the root passsword and enter the following below, but nothing happens

    mysql> CREATE USER ‘phptest’@'localhost’ IDENTIFIED BY ‘phptest’
    ->

    Any help?

    TIA,

    Raul

51. 51 On November 24th, 2008, Raul Rosa said:

    OK, I resolved my first issue. I got the the test account created on MySQL.

    No I am stuck, and cannot get my can’t get my index.php page to recognize MySQL.
    I’ve tried all the suggestion above with no success.

    Any help will be greatly appreciated.

    Raul

52. 52 On December 23rd, 2008, Tony said:

    Everything worked (once I moved php.ini to C:\windows) except that last step http://localhost/dbtest.php. I get “THE WEBPAGE CANNOT BE FOUND”. The test to http://localhost/phpinfo.php works just fine.

53. 53 On January 5th, 2009, Brett Malpas said:

    I followed this guide to the letter and was getting “PHP Access Denied” Errors running the dbtest.php fixed by checking the permissions on the mysql folder make sure they are inheriting with both box ticked in advanced fixed my problem.

54. 54 On January 8th, 2009, Samuel said:

    Thanks Paul for this insightful tutorial.

    My question is
    After installing PHP and MySQL, can I still be able to run ASP.NET pages simultaneously?

    We have a production server running .NET 1.1, however, I want to install Wordpress, which requires PHP and MySQL (I don’t know any other .NET blog alternatives) and I have been having serious difficulties getting information that will allow me run Wordpress, and yet not disrupt the other .NET applications running on the server.

    Any information is greatly appreciated.

55. 55 On January 9th, 2009, Paul Lynch said:

    Samuel,

    Yes it is possible to run WordPress on a server which also requires .Net - you can either create a separate web site with its own unique identity (host header) for your WordPress installation or simply create a new virtual directory on your existing web site to host your WordPress blog. If you are going to use an existing web site which requires .Net I would caution against running the script in my PHP installation as this removes all other scriptmaps leaving only PHP - this would obviously break your .Net apps. Instead I would add the PHP scriptmap manually to your existing site.

    Hope this helps.

    Paul

56. 56 On February 1st, 2009, Steve said:

    For those who can’t see the mysql extension in the php info window, i had the same problem, i did a full search on my C drive and found an old version of libmysql.dll in my windows directory from an old failed installation, i deleted it and it all works great now.

57. 57 On March 18th, 2009, Fugitive said:

    good tutorial, but i had the problem of connecting to MySQL, i got the error:
    Call to undefined function mysql_connect()
    After doing some research i notices that configuration file didnt point to C:\PHP\php.ini so i found out that i didnt add the PHPRC Envoriment variable with value C:\PHP. I never saw this step in this tutorial, and also copied libmysql.dll to windows\system32
    Thanks

58. 58 On March 18th, 2009, bob said:

    Paul - Thanks so much for a great resource! I’ve gotten most of the configuration to work. I cannot run any of the wordpress php file–the browser spins a long time and gives me a 500 error:
    2009-03-18 18:36:16 W3SVC1 127.0.0.1 GET /blog/index.php - 8080 - 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506.30;+.NET+CLR+3.0.04506.648;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729) 500 0 0

    The dbtest.php file works when using the phptest user, but I tried to modify it to run against my wordpress database, and it won’t work. With it, i get a 500 0 64 error.

    Any help would be great!
    Bob

    I’m running against localhost:8080 since I’ve already got an instance on port 80.

59. 59 On March 19th, 2009, Paul Lynch said:

    Bob,

    The fact that the dbtest.php page works OK proves that your installation is good - I included it to provide a means for you to validate your build. I can only now assume that WordPress is failing due to some permissions issue within MySQL. Check that the login credentials in the file do actualy work - you can do this by logging into MySQL with them using the GUI Admin tools for MySQL.

    Also, you don’t have to run on port 8080 - you can assign a host header to your WordPress web site and it can also listen on port 80.

    Regards,

    Paul Lynch

60. 60 On April 30th, 2009, alf eli said:

    cool its working ok i also would like to see a phpmyadmin tutorial and if possible a joomla tutorial

    tks mate

    good work

61. 61 On May 18th, 2009, Welcome | FatFrame.com said:

    [...] First of all I would like to thank the author of these tutorials: http://www.iisadmin.co.uk/?p=4 http://www.iisadmin.co.uk/?p=5 http://www.iisadmin.co.uk/?p=6 These articles helped me get this site up and hosted personally in [...]

62. 62 On September 4th, 2009, ethos said:

    Copying the php.ini to the C:\WINDOWS directory worked for me also.

63. 63 On January 2nd, 2010, Chin said:

    thanks to paul lynch for the tutorial

    everytime I open a php file with mysql code the server ask me to login (not mysql login). how do I turn it off?

    Chin

64. 64 On January 2nd, 2010, Chin said:

    … by the way for ppl with the phpinfo-I-cant-see-MySql-Box problem I solved it with PHPRC thingy.

65. 65 On January 8th, 2010, Chin said:

    hi all,

    i finally solved most every problem.

    if u r using iusr_[machine] as anonyme user and u need to add localservice to webroot with read + execute privs, unless u want ur clients to login onto the machine.

    ^^ chin

Leave a Reply