TUTORIAL: How to install PHP and MySQL on IIS

  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: 28 May 2003
  • Posts: 19508
  • Loc: Pittsburgh PA
  • Status: Online

Post 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.
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post May 10th, 2006, 5:35 am

  • malakite
  • Born
  • Born
  • No Avatar
  • Joined: 10 May 2006
  • Posts: 3
  • Status: Offline

Post 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
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: 28 May 2003
  • Posts: 19508
  • Loc: Pittsburgh PA
  • Status: Online

Post 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.
  • dyfrin
  • Graduate
  • Graduate
  • No Avatar
  • Joined: 10 May 2006
  • Posts: 202
  • Loc: WI
  • Status: Offline

Post 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.
  • malakite
  • Born
  • Born
  • No Avatar
  • Joined: 10 May 2006
  • Posts: 3
  • Status: Offline

Post May 11th, 2006, 12:43 am

Thanks a lot everyone! i got it working by using DOS commandline, thanks again.
  • Jepps98
  • Graduate
  • Graduate
  • User avatar
  • Joined: 28 Nov 2004
  • Posts: 149
  • Loc: Umm, not exactly sure...
  • Status: Offline

Post May 16th, 2006, 5:48 pm

Umm, I need the username and password? What would it be?
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: 28 May 2003
  • Posts: 19508
  • Loc: Pittsburgh PA
  • Status: Online

Post 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.
  • Jepps98
  • Graduate
  • Graduate
  • User avatar
  • Joined: 28 Nov 2004
  • Posts: 149
  • Loc: Umm, not exactly sure...
  • Status: Offline

Post May 17th, 2006, 8:10 pm

Cant get it to work... And I didnt set a PW
  • Evenhost
  • Graduate
  • Graduate
  • User avatar
  • Joined: 29 Aug 2006
  • Posts: 182
  • Loc: Florida
  • Status: Offline

Post 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 :)
Join our growing community of webmasters and WOW players at the Even Hosting Forums: www.evenhosting.com/forum

Get FREE traffic to your website today! www.eventraffic.com
  • joeshmoe2469
  • Born
  • Born
  • No Avatar
  • Joined: 02 Oct 2006
  • Posts: 1
  • Loc: washington
  • Status: Offline

Post October 2nd, 2006, 7:32 pm

can any one tell me about overclocking my com
  • suzannehami
  • Born
  • Born
  • No Avatar
  • Joined: 30 Oct 2006
  • Posts: 2
  • Status: Offline

Post 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
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: 28 May 2003
  • Posts: 19508
  • Loc: Pittsburgh PA
  • Status: Online

Post 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.
  • suzannehami
  • Born
  • Born
  • No Avatar
  • Joined: 30 Oct 2006
  • Posts: 2
  • Status: Offline

Post 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
  • imranahmed
  • Newbie
  • Newbie
  • No Avatar
  • Joined: 21 Dec 2006
  • Posts: 10
  • Loc: UK
  • Status: Offline

Post December 21st, 2006, 4:42 pm

Nice tutorial, realy helped me in configuration. I was stuck from many days to do setup. thanks again
  • zengqiang
  • Born
  • Born
  • No Avatar
  • Joined: 11 Jan 2007
  • Posts: 1
  • Status: Offline

Post January 11th, 2007, 9:05 am

thank you for your tutorial.
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post January 11th, 2007, 9:05 am

Post Information

  • Total Posts in this topic: 142 posts
  • Moderators: joebert, katana
  • Users browsing this forum: No registered users and 101 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© Unmelted Enterprises 1998-2008. Driven by phpBB © 2001-2008 phpBB Group.

 
 
 
 

Need a pre-made web design for your website?

Check out our templates here: Ozzu Templates


400+ FREE Website Templates. Download Now!