TUTORIAL: How to install PHP and MySQL on IIS

[ATNO/TW]

May 10th, 2006, 5:35 am

Your question isn't entirely clear. The only part that I know of in the install that would require internet access is where you are prompted to register with MySQL.org That is an optional part of the install. You can skip that.

May 10th, 2006, 8:05 am

yeah i got that and skipped it!
basically after hitting execute button,
It has frozen up during the final step (MySQL Server Instance
Configuration).

I'm installing it on Windows XP, and I used all the
default settings, except that I changed "Detailed Configuration" to
"Standard Configuration".

At the "Start Service" item in the checklist,
I got a 1045 error message saying to allow TCP port 3306.

also after re-running it, it puts a red 'x' in the "Start service" checklist and says "The service could not be started. Error: 0"

i dont know what is wrong

[ATNO/TW]

May 10th, 2006, 10:26 am

It's because the service was most likely already running. I remember running into that a couple times myself. If I recall correctly, just reboot the computer and you should be fine.

May 10th, 2006, 11:47 am

As part of the install:
Make sure you update the mysql client for php.

After installing mysql copy libmySQL.dll from the mysql installation to the c:\php directory, overwriting the previous.

May 11th, 2006, 12:43 am

Thanks a lot everyone! i got it working by using DOS commandline, thanks again.

May 16th, 2006, 5:48 pm

Umm, I need the username and password? What would it be?

[ATNO/TW]

May 17th, 2006, 7:45 am

username is: root. Unless you set a password during install there is no default password. Just leave it blank.

May 17th, 2006, 8:10 pm

Cant get it to work... And I didnt set a PW

September 20th, 2006, 1:35 pm

its great to see a PHP how to guide. I just went through instaling a php database and it was a pain the but to do on my own with only basic knowledge. I found this just a day too late

October 2nd, 2006, 7:32 pm

can any one tell me about overclocking my com

October 30th, 2006, 5:48 am

Hi
I'm very frustrated
I've followed the instructions for installing all the bits.
MySQL works
PHP works
My IIS works
MySQL Admin Tool works
phpMyAdmin doesnt work

I'm continously getting the

Cannot load mysql extension. Please check your PHP configuration. - Documentation

error - my php.ini file looks like this (at the moment, but has looked several different ways)

; Directory in which the loadable extensions (modules) reside.
extension_dir = "C:/PHP/ext"
extension=php_mbstring.dll

My config.inc.php file looks like this:

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'config';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pmausr';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';


should i add in the other bits from the instructions to the config.inc.php file?
ie. these bits:

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?

$cfg['Servers'][$i]['user'] = 'root'; // MySQL user

$cfg['Servers'][$i]['password'] = 'yourpassword'; // MySQL password (only needed

// with 'config' auth_type)

cos my config.default didnt have them so i didnt add them, could this be the problem?
I've tried moving the php_mbstring.dll file to different places within the php folder but no luck ... I'm completely baffled as to why this isnt working.
Thanks for any help
Sue

[ATNO/TW]

October 30th, 2006, 8:09 am

Under Windows extensions in php.ini uncomment

extension=php_mysql.dll

Make sure php_mysql.dll exists in the extensions folder.

October 30th, 2006, 10:55 am

hi
Thanks for that, it worked.
I now have a new problem - I know I should try to find the answer myself but I'm hoping you'll know quickly and save me a few hours searching and experimenting
Anyway, now I've got the error

MySQL said
#2003 - The server is not responding

I know the server is working (IIS)

where do i need to go to fix this?

Thanks
Sue

December 21st, 2006, 4:42 pm

Nice tutorial, realy helped me in configuration. I was stuck from many days to do setup. thanks again

January 11th, 2007, 9:05 am

thank you for your tutorial.