Comments on: How To Install MySQL and PHP on IIS 6.0

By: Zuppy

Zuppy — Sat, 13 Mar 2010 22:19:58 +0000

Great great tutorial.
I’ve istalled both PHP and mysql…. theyr uns fine alone…but when I try to load the mysql from php nothing to do…I’ve checked 3 times all, the ext path…. in the ini…. I’ve added the path bot as PHPRC both in registry to be sure of that… npthing… with the test php file to see the pho variables and so on… i get all but not mysql.
If someine can try to hel p and ask me I can post the capture you need… :((((

PS: php runs ok from www on the virtual server.

thanks

Zuppy

By: Chin

Chin — Fri, 08 Jan 2010 00:43:43 +0000

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

By: Chin

Chin — Sat, 02 Jan 2010 04:53:43 +0000

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

By: Chin

Chin — Sat, 02 Jan 2010 04:50:01 +0000

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

By: ethos

ethos — Fri, 04 Sep 2009 04:35:35 +0000

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

By: Welcome | FatFrame.com

Welcome | FatFrame.com — Mon, 18 May 2009 01:06:24 +0000

[...] 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 [...]

By: alf eli

alf eli — Thu, 30 Apr 2009 09:30:04 +0000

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

tks mate

good work

By: Paul Lynch

Paul Lynch — Thu, 19 Mar 2009 13:30:12 +0000

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

By: bob

bob — Wed, 18 Mar 2009 19:16:20 +0000

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.

By: Fugitive

Fugitive — Tue, 17 Mar 2009 23:01:21 +0000

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