Installing Apache + PHP + MySQL

[Xylene]

Running a webserver on Windows.. :x :no:

[Large]

  Xylene said:

Running a webserver on Windows.. :x :no:

Whats so wrong with a webserver running on Windows, I have often used WAMP servers, theres nothing wrong with running a webserver on Windows !!!

[raider360]

hi all :)

I have one question about MySQL. When I am installed it, I have already some users. There are: "@%", "@localhost", "root@%", "root@localhost". What is this means? :huh:

Can I make only 1 user with all privileges?

Edited September 16, 2004 by RaiderOnline

[Ultra Frosty]

What is that program you took at screenshot of called?

[Garry]

Isn't the PHP asapi module for Apache 2 still experimental? I know when I tried it (over a year ago now) it didn't work too well.

[Large]

Apache 2 works fine now, I have installed an Apache 2, MySQL and PHP webserver and they all work fine together on Windows !

[vhane]

  RaiderOnline said:

hi all :)

I have one question about MySQL. When I am installed it, I have already some users. There are: "@%", "@localhost", "root@%", "root@localhost". What is this means? :huh:

Can I make only 1 user with all privileges?

The format is this: user@hostmask

"%" is a wild card. A blank username and a wildcard after the "@" means that "@%" is an anonymous user that can connect to your server from any host. I'd advise deleting the account. I'd advise deleting the anonymous user that can connect from localhost too. So, delete "@localhost" also.

"root@%" Means that root can connect from any host. You may or may not want this. Consider allowing root to connect from localhost only, or only from a box on the LAN. For example:

"root@192.168.0.%"

I would advise you to create a user for your own use, with priviledges granted for specific databases only.

[lefty]

This is an awesome guide. Good job :)

[Ultra Frosty]

I'm looking at PostgeSQL, as it now supports Windows. I'll do some tests and write a setup guide along with a comparison between the two as soon as I can.

[Ultra Frosty]

Okay. I updated the guide and Redid the MySQL install for the new MySQL 4.1. It should be a lot easier for people to setup with the installer and not needing to use the command line for everything.

[Jervous]

Is there a way to do the same thing for PHP 5?

[Ultra Frosty]

  Jervous said:

Is there a way to do the same thing for PHP 5?

584883037[/snapback]

I don't recommend using PHP5 to any novice users, as the only feature that catches my eye is very good OOP support. But, just change the code in httpd.conf to:

LoadModule php5_module "C:/PHP/php5apache2.dll"
AddType application/x-httpd-php .php

and copy php5ts.dll to your C:\WINDOWS\system32 directory.

[Jervous]

PHP 5 is actually better to start learning now, as it is still in an early age, so by the time you have learned some of the things needed in scripts a stable release will be out and you can.

Also, since you install PHP, you want Apache to recognize index.php and make it the first page you see when you visit the directory, so you would have to do this aswell:

Open C:/Apache2/conf/httpd in Wordpad or Notepad or whatever you use and find:

DirectoryIndex

and after that you have to add

index.php

If you use home.php or something different just add home.php, etc.

[msg43]

Might give this a try was using a preinstalled but I like learning new things.

[raider360]

  b0b said:

What is that program you took at screenshot of called?

584572634[/snapback]

It's a MySQL Control Center ;)

[raider360]

  vhane said:

The format is this: user@hostmask

"%" is a wild card. A blank username and a wildcard after the "@" means that "@%" is an anonymous user that can connect to your server from any host. I'd advise deleting the account. I'd advise deleting the anonymous user that can connect from localhost too. So, delete "@localhost" also.

"root@%" Means that root can connect from any host. You may or may not want this. Consider allowing root to connect from localhost only, or only from a box on the LAN. For example:

"root@192.168.0.%"

I would advise you to create a user for your own use, with priviledges granted for specific databases only.

584575295[/snapback]

wow :woot: thanks :D Now I can understand all this stuff :p

[DrRip]

Somehow it does not work for me...apache works fine....then on to step 2 PHP .... i cant'get that to work...

I did all that is listed in the guide

get this error

LoadModule takes two arguments, amodule name and the name of a shared object file to load it from

Edited December 1, 2004 by DrRip

[gringo]

:woot: nice guide??? downloaded!!! thanks1!! :D

[[ timko ]]

Guide good.

However, I've started using...

http://www.apachefriends.org/en/xampp.html

:)

[Nelsinho]

good job dude. awesome guide (Y)

[Ultra Frosty]

Now updated

- Modified some wording.

- Added some screenshots to help beginners.

[littleman]

Nice tutorial!!!

Although after i downloaded the php (installer exe) i found that none of the directories such as sapi and files such as php.ini-recommended were in the c:\php directory so i just downloaded the Zip file and extracted it in and all was well.

Thanks again!

[timsweb]

nice, going to try this, is it easy to add phpmyadmin into it as well?

[konstantinos]

how about using the foxserv project software? it has a funky panel too.

[iron2000]

Was trying to install the trio for a project.

Found tutorial on this site and followed it:

http://www.webmasterstop.com/48.html

But theres a nice tutorial at Neowin too.

:D