pureMango.co.uk

there's nothing about mangos or purity. It's just a name..



Working with PDF documents is easy and quick. You can find great deals on PDF conversion software online. The convenient PDF to Excel converter also works to convert PDF to Word documents. Check out this great PDF software today!
easy guide to installing WAMP - Windows Apache PHP Mysql  Setting up WAMP

This article will step through what you need to do get WAMP (Windows, Apache, mySQL, PHP) running on windows 2000, 98 or XP. (It might work with ME or 95, but I don't promise anything)

By the end, you'll have a versatile tool that will allow you to:

-host your own website (permanent internet connection preferable)
-learn a basic programming language (PHP)
-learn about relational databases (mySQL)
-learn about server config on the industry standard webserver (apache)

all without having to install a new operating system.

Required tools:
a fairly clean basic box, e.g.:
ram: approx 256Mb+
mhz: approx 700+
HDD: approx 200Mb free
Admin access to your box (not required on win98-).

Estimated time: MAX 2 hours.

By 'fairly clean', I mean close to it's original condition; the fewer things installed on it the better. Of significant concern are things like firewalls, almost anything by norton, AOL, third party secuity suites, etc. Ideally, you'll want to re-install the whole computer from scratch, but this is by no means required.

easy guide to installing WAMP - Windows Apache PHP Mysql  Getting Started

Firstly, you may like to print this page, not only will you undoubtably need it at some future point, but also, we'll be disconnecting from the net while we do the install.

Click here for a printer friendly PDF of this page (thanks to Siv for the PDF), or click here change to the 'text' scheme.
Note that the PDF is not updated as often as this page is (like, never), so try the text scheme first and if that won't work, then use the PDF (or just forget the whole thing)...

Secondly, you'll need to download all the installers for the programs we'll be installing;

download Apache 1.3.33 (from www.apache.org)
download PHP 5.02 (from www.php.net)
download mySQL 4.0.21 (from www.mysql.org)

or go to the respective websites and grab the latest versions, but I can't guarantee that this guide will work with other versions.

Note: this guide is designed for mySQL 4.0.21, however mysql.org no longer distribute that version, hence, the link to mySQL is for 4.0.23. This should not affect the guide. I do plan to host all install files locally at some point.

If you don't have something capable of reading zip files (e.g. winzip) then I suggest zipcentral (zipcentral.iscool.net), it's fast and quite a lot free-er than winzip :-).

I also recommend downloading textpad (www.textpad.com); it's just a text editor, but it has some nifty features that make coding PHP (or any other language) a lot easier.

Now, reboot your computer. This is important as it will ensure that your system is fresh and ready to kick some ass.

If you're running win2k, log in as the administrator.
Disconnect from the internet
If you have one, disable your firewall. In fact, disable everything that's running; no taskbar icons, no extra status bar icons. This will help ensure the install goes smoothly.

easy guide to installing WAMP - Windows Apache PHP Mysql  Installing Apache

Apache is the web server, which processes file requests and sends them back. Apache is generally recognised as the most stable and secure server money can buy. Not that money is an issue, as it's also totally free, like all the tools we're using.

I have to say, installing Apache on windows is incredibly simple, a few clicks and it's done.

First, open the Apache install file you downloaded, click yes and ok and next and so forth until you reach the "Server Information" screen, then, here's the info you want:

Network Domain: localhost
Server Name: 127.0.0.1
Admin Email: you@yourdomain.com

Choose whether you want Apache running for all users or not.
If you just going to use the server for development, you can just have it run for you, otherwise I'd recommend having it running for all users.

Choose the complete installation (it only takes under 8 meg, so why not?), stick with the default folder for install, and hit the magic button.

This should be it - verify by opening http://localhost/ or http://127.0.0.1/ in your internet browser.

Wasn't that easy?

easy guide to installing WAMP - Windows Apache PHP Mysql  Installing mySQL

mySQL is the database server, which will allow interactivity on your websites. Like Apache, mySQL is free, stable and secure. It lacks a few of the features of it's commercial competitors, but is widely used and trusted. With each new version, more features are added to keep mySQL a viable alternative to other closed source products (Oracle and MSSQL being the two main rivals)

Extract everything from "mysql-4.0.21-win-noinstall.zip" straight into drive C, a new folder should appear named "mysql-4.0.21-win", you can rename this something else if you want to, it really doesn't matter (but bear in mind that that's what I use, so my config examples are tailored to this directory).

mySQL is now installed, but there's a little configuring you'll need to do.

Firstly, let's set a password:
Start a command prompt by going to Start, then Run, and typing "command", or on win2k, "cmd"

To start the mySQL daemon, type the following:

c:
cd mysql-4.0.21-win
cd bin
mysqld


exit that command prompt, and start a new one, again navigating to c:\mysql-4.0.21-win\bin\

now type

mysql -u root

to log in to mySQL, it should say

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.0.21-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Note: If you get a message saying that you cannot connect, try rebooting and running 'mysqld' again.

Now type the following, replacing "flibble" with your desired password for the mySQL server.

USE mysql;
UPDATE user SET Password=PASSWORD("flibble");
FLUSH PRIVILEGES;
exit;


Ok, so now you've set the password for all default accounts, all we need to do is get the server to run automatically, on startup (if you don't want mySQL to run every time you turn on the computer, then skip this step)

To run mySQL for all users:
Create a shortcut to c:\mysql-4.0.21-win\bin\mysqld.exe in C:\Documents and Settings\All Users.WINNT\Start Menu\Programs\Startup

To run mySQL for just you
Create a shortcut to c:\mysql-4.0.21-win\bin\mysqld.exe in C:\Documents and Settings\your_username_here\Start Menu\Programs\Startup

easy guide to installing WAMP - Windows Apache PHP Mysql  Installing PHP

This is easy;

Extract php-5.0.2-Win32.zip to c:\php\

Create a folder named "sessiondata" inside c:\php\

Take "C:\php\php.ini-recommended", and copy it to "C:\WINNT\php.ini" (or C:\windows\php.ini), making the following changes:

LineOld ValueNew Value
353display_errors = Offdisplay_errors = On
636;extension=php_mysql.dllextension=php_mysql.dll
PHP is now installed.

easy guide to installing WAMP - Windows Apache PHP Mysql  Getting the left hand to know what the right is doing

Firstly, we need to let Apache know that it should process .php files as PHP code:

open C:\Program Files\Apache Group\Apache\conf\httpd.conf in a text editor (eg notepad or textpad)

Scroll to the bottom, and add the following lines:

# add PHP5 as an apache module
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
LoadModule php5_module "c:/php/php5apache.dll"
SetEnv PHPRC C:/php


Note: in this section, you can specify any type of file to be run through PHP, for instance, some servers use:

AddType application/x-httpd-php .htm
AddType application/x-httpd-php .html


as well as .php; this may result in some performance issues, as every html file will be run through PHP to be processed. The benefit is that search engines sometimes place slightly higher value on html files. Also, it makes it ever so slightly harder for hackers to determine which files are PHP.

Generally, though, there is no reason to do this. It gets confusing when you're developing code if you don't know whether blah.html is a PHP file or not, or if you need to change servers at a later date.

Now, to allow Apache to serve index.php as the default page, search for "DirectoryIndex index.html" (line 385), and edit it to read

DirectoryIndex index.html index.php

Now, to allow PHP to find the mySQL functions, copy the following files:

c:\php\libmysql.dll
c:\php\ext\php_mysql.dll

to c:\WINNT\ (or C:\windows\, depending on your setup)

Ok, all done, now we need to restart Apache;
Open a command prompt and type:

net stop apache
net start apache


easy guide to installing WAMP - Windows Apache PHP Mysql  Testing whether it worked

Apache stores the website files in "C:\Program Files\Apache Group\Apache\htdocs"

If you open that directory, you'll see there's a bunch of files there, you can delete everything, though you may need the 'manual' directory later.

Make sure that windows is set up to show all file exensions (Tools|Folder Options|View, untick "Hide file extensions for known file types". On windows98, it's under 'view', not 'tools'.)

Now, to test PHP, create a new text document with the following content, and name it "info.php":

[?
phpinfo();
?]

(replace [ and ] with the less than and greater than signs)

open http://localhost/info.php in your browser, and marvel at the wonders of PHP.

you should see the standard phpinfo page, which tells you almost everything you need to know about your install of PHP.

Let's see if mySQL is working.

Create mysql.php in htdocs, and place this content in it:

[?
// connect to the server:
$cn = mysql_connect("127.0.0.1","root","flibble");

// run a simple query
$sql = "SELECT 'done' as my_field LIMIT 1";
$result = mysql_query($sql,$cn);

if($result)
{
  // if it worked, print the result to screen
  echo mysql_result($result,"my_field");
} else {
  // otherwise, either the server isn't running
  // or the username/password are wrong
  echo mysql_error()."<br />You should see an error message above you?";
}
?]

(replace [ and ] with the less than and greater than signs)

Now open http://localhost/mysql.php, and you should see a message saying 'done'.

You may now delete info.php and mysql.php

Take some time to look through the manual (http://localhost/manual/) there's some useful stuff in there.

Also, learn to love php.net; their function reference is second to none.

If you get any error messages or problems along the way, email email me
with details of your operating system, version of apache, mysql and php and details of the error, include error messages if you get them.




There's a PHP/mySQL tutorial in the pipeline, keep checking back or email me if you want me to send you a link when I'm done with it. In the meantime, check out PHP.net's own tutorial.

For some sample PHP scripts to test out your new server, check out the projects page.

If you found this useful, please vote!




 User Comments:

Who: p2
When: December 4th, 2004
Says: sweet guide. i actually saw a t-shirt that said "WAMP" on it, and made a mental note to look it up. now i don't have to make an extra effort. :)

Who: Me
When: December 16th, 2004
Says: nice, but i get an error on mysql.
Fatal error: Call to undefined function mysql_connect() in c:webservermysql.php on line 5

it seems to cannot find the mysql functions?
ty

Who: u24
When: December 16th, 2004
Says: that's probably either because PHP can't find php_mysql.dll (you need to move it to your windows directory and edit PHP.ini as shown above)

or, you haven't yet restarted apache. If you have done both of those, try rebooting and giving it another go.

What Operating System are you running?

Who: Me
When: December 19th, 2004
Says: I see this error: Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:Apache2htdocstestconnect.php on line 3

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:Apache2htdocstestconnect.php on line 7
Client does not support authentication protocol requested by server; consider upgrading MySQL client

----
u24: what operating system are you using + did you use the versions of apache and mysql that I suggested? - it looks like you've installed apache 2; this guide may not work with that version.

Who: Ahmad
When: December 25th, 2004
Says: Excellent guide, worked flawlessly. Good stuff! =)

(You should change "Estimated time: 2 hours", to "Estimated time: 10 minutes!" ;))

...might I add I was using WindowsXP-SP2

Who: pp
When: December 25th, 2004
Says: nice, good work!

Who: charlie
When: January 2nd, 2005
Says: Wow! This has to be one of the best guides I have ever used. After having looked throughout all sorts of other guides/faqs/forums, nothing came close to how easy this made things. Great job to any that worked on it!

Who: email address imagified
When: January 13th, 2005
Says: If MySQL 4.0.21 is not available in mysql.org site (as per the URL you had recommended http://dev.mysql.com/get/Downloads/MySQL-4.0/mysql-4.0.21-win-noinstall.zip/from/pick#mirrors) what is the version that I can download so that your tutorial will take me to install mysql server in my machine. I am putting this question to you b'cause when I clicked that link, I got an error message that 4.0.21 is not available in their site. Could you help, please?

Who: u24
When: January 13th, 2005
Says: well spotted - they must have only just done that. I've changed the guide to link to mySQL 4.0.23 - let me know how you get on. Soon I'll have the correct versions linked above (when I buy a new USB pen drive...)

Who: email address imagified
When: January 14th, 2005
Says: The link description for MySQL still reads MySQL 4.0.21 and you can correct it as 4.0.23.
You can help your visitors to have a pdf link to enable them to have a print out of the whole tutorial before they start the installing exercise, which I had done myself. I had sent a mail to you with pdf attachment to enable you to put it in your server and help your visitors take a print out. It's only a suggestion which you can act upon your conveniece.

Who: Scott
When: February 3rd, 2005
Says: Ok, Followed the directions exactly as listed. Have everthing installed and moved to the correct directories on my machine. Edited and changed all files as in your documentation. Moved them to the correct directories. When I get to Now Let's test it to see if everything is working. I get the following error message when doing a net stop apache. System error 1060 has occurred. The specified service does not exist as an installed service. Can anyone offer any suggestions ??

------
from u24: try rebooting, if that doesn't fix it, then try

net start apache
net stop apache
net start apache

if that doesn't do it, then try looking at c:(whereever apache is)logserror.log and see if anything seems to relate to that error (eg: 'apache service failed to start' or similar)

Who: Add to comment above.
When: February 3rd, 2005
Says: When running a test configuration on Apache.. Get the following error message: Cannot load c:phpphp5apache.dll into server; The specefied module could not be found.... It's in the PHP directory and I have it added to Appache's httpd config file. Checked and re-checked for errors, can't find any !

---
from u24: try moving php5apache.dll to your windows directory

Who: Scott
When: February 5th, 2005
Says: I think I've got this figured out, not sure but will test when I can.. Busy weekend..

Who: mlichtenstein2hotmail [.] com
When: March 25th, 2005
Says: I am unable to find the httpd.conf file. I have installed both tomcat 4 and 5, but the file is not there in either version. Any Suggestions?

---
from u24:
try searching for *.conf
I'll be able to give more support next week (been away from computer for long time)

Who: email address imagified
When: May 2nd, 2005
Says: I followed your instructions to the letter, keep gettting this error.

F:mysql-4.0.23-winbin>mysql -u root

ERROR 1045: Access denied for user 'root'@'localhost' (using password: NO)

Any ideas?
---
from u24:
you're trying to set the password, ja?
try
mysql -u root -p

Who: u24
When: May 2nd, 2005
Says: actually, that's really strange, if you haven't set a password, you should be let right in. Try deleting the mysql folder and re-extracting it..

Who: email address imagified
When: May 4th, 2005
Says: i followed all the instructions and i received this message:

Fatal error: Call to undefined function mysql_connect() in c:program filesapache groupApachehtdocsmysql.php on line 3

wut do i do now?!?!

---
from u24: are you sure you've moved php_mysql.dll into your windows folder and uncommented the "extension=php_mysql.dll" line in php.ini, and restarted the apache server? If so, what version of windows are you using?

Who: email address imagified
When: June 4th, 2005
Says: there's an unupdated line in your tutorial:

LoadModule php5_module "c:/php/php5apache.dll"

now in new php version the right module is php5apache2.dll.

So the line correct is: LoadModule php5_module "c:/php/php5apache.dll"

I lost about 30 min to understand why the apache server didn't started!

However your tutorial is great, I find it very useful, thanx.

Livio

Who: Hasan
When: June 4th, 2005
Says: It worked very very very easy tutorial

Who: DTC
When: June 5th, 2005
Says: followed to the word. Apache installed fine, PHP installed fine MySQL installed wrong. getting this message when i try to view my page...
Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'root@localhost' (Using password: YES) in c:Apachehtdocsmysql.php on line 3

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:Apachehtdocsmysql.php on line 7
Access denied for user: 'root@localhost' (Using password: YES)
You should see an error message above you?


I will say that when i installed MySQL i couldnt configure it via command line prompt as it wouldnt let me so i did it by finding the files and executing them myself. I supose from re-reading your tut i may not have set a password. n e 1 know how to remedy this??
----
from u24:
try just re-installing mySQL as per the instructions above.

Who: email address imagified
When: June 8th, 2005
Says: Excellent guide I have ever seen on the net.

Before I found your site I already spent approximately 14 hours.... I looked around all sorts of FAQs and Forums which provided no solutions but a huge CONFUSIONS!

After reading your guide it took me 40 minutes to get it all talking to each other. This has to be one of the best guides I have ever used.

Thank you very much

Who: iso
When: June 9th, 2005
Says: Thank you, I found this useful

Who: amrit
When: June 20th, 2005
Says: For php 5, the php5apache2.dll should be placed in the php directory and not php5apache.dll.

Who: email address imagified
When: July 14th, 2005
Says: I cant make wamp work as a simulated web server to send emails, I have it working to view my php and sql pages but when I try to send an email with a form I get:

Warning: mail() [function.mail]: Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in (my written code page).

I really have no idea what to do, I downloaded Argosoft because on wamp's site they said I could use that, I cant figure out how to configure it right.
Any help would be appreciated thanks.
---
from u24:
yeah, it's very probable that mail won't work from a local server unless you're running an smtp daemon; search google for windows smtp server

Who: email address imagified
When: July 19th, 2005
Says: Hi,

I have installed the following version from their respective sites.

1. Apache 1.3.22
2. PHP 5.0.2
3. MySQL
4.1.12a

Further, I have followed all the instructions found in this tutorial.
PHP works fine but when I try to run the following mysql.php script.

Birthdays Create Database



Who: rsasalm
When: July 20th, 2005
Says: Hi all,
I have installed the following version from their respective sites.

1. Apache 1.3.22
2. PHP 5.0.2
3. MySQL
4.1.12a
All on winXP pro.

Further, I have followed all the instructions found in this tutorial.
PHP works fine but when I try to run the following mysql.php script.


Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:Apache2htdocstestconnect.php on line 3

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:Apache2htdocstestconnect.php on line 7
Client does not support authentication protocol requested by server; consider upgrading MySQL client

What is missing?
/rsasalm

Who: Fpa
When: July 20th, 2005
Says: Nice Tutorial But Why Choose WAMP When You Can Choose LAMP :)

Who: Fpa
When: July 20th, 2005
Says: [quote]
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:Apache2htdocstestconnect.php on line 3

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:Apache2htdocstestconnect.php on line 7
Client does not support authentication protocol requested by server; consider upgrading MySQL client
[/quote]

did you set a mysql root password?
is mysql running?
what version of mysql?



Who: Fpa
When: July 20th, 2005
Says: [quote]
I cant make wamp work as a simulated web server to send emails
[/quote]

sounds like you dont have a smtp server installed on yur server... eudora or 1st SMTP work quite well. if you dont wanna run one locally specify a remote one in your mail() i.e one yur ISP provides (but wont work too well since relaying has been patched on 99% of SMTP's out there)

Who: rsasalm
When: July 20th, 2005
Says: Hi again,
Thanks Fpa for responding to my mail.
I have followed the tutorial as it is.

I have set the password as below as described in the tutorial.
************
USE mysql;
UPDATE user SET Password=PASSWORD("flibble");
FLUSH PRIVILEGES;
exit;
*************
I am using MySQL 4.1.12a.
I can see in the task manager that MYsqld is running but when I try to run mysql via dos command I get the following error:
C:mysql-4.1.12a-win32bin>mysql
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

Any comments.
thanks
regards
/rsasalm

---
from u24:
try using this command instead:

mysql -u admin -p

the command you used above was trying to login without a username or password.

Who: email address imagified
When: July 26th, 2005
Says: i installed the apache 2.0.54, php 5.0.4 and mysql 4.1.13 on winXp i have the error message: Call to undefined function mysql_connect()...
i check myself twice and i done it all as you inscribe
---
from u24:
weird... try installing everything again.

Who: email address imagified
When: July 31st, 2005
Says: I've followed all the instructions, and the PHP file works, but not the mySQL one. I get the same error messages as posters above (and i did put in my own password):
"Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:program filesapache groupApachehtdocsmysql.php on line 3

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:program filesapache groupApachehtdocsmysql.php on line 7
Client does not support authentication protocol requested by server; consider upgrading MySQL client"

I've installed Apache 1.3.33, PHP 5.0.2, & mySQL 4.1.13. Could it be the mySQL version that's messing it up?
---
from u24:
possibly, try re-installing it first, and make sure you've moved the dlls and editing php.ini, if that doesn't work, try installing a different version of mysql

Who: email address imagified
When: August 2nd, 2005
Says: Thanks for the guide, along with a few others I've finally got a win98 server going


Who: email address imagified
When: August 9th, 2005
Says: very goooooooooooood

Who: rf
When: August 10th, 2005
Says: I'm trying to run Apache on Win 2000 Pro but the service won't start - when i try to start it from the services applet it just says that the service terminated unexpectedly. Any ideas?
---
from u24:
strange; that's what I'm runing at home and everything is fine; try uninstalling apache and putting on a different version, or just re-installing the same version.

Who: email address imagified
When: September 14th, 2005
Says: Hi ,
I am still wondering that if i want to view my webpage from the client side . What i need to do?

thanks

Who: leo d [.]
When: September 17th, 2005
Says: when you install WAMP on a single machine and you want to test it, the host name is LOCALHOST or IP addy is 127.0.0.1

so http://localhost/index.htm

or

http://127.0.0.1/index.htm

will work...
---
from u24:
yup, and if you want to view the page from another machine, just go to http://your.ip.address.here/

you can find your IP address on many sites out there (including this one)

Who: email address imagified
When: October 10th, 2005
Says: I followed the instructions and it worked fine when installing it to my laptop c: but I wanted to install it the the d: of my PC (C: is win2k, D: is WinXP) i am having problems.

Before I started editing the php,ini file etc I tested Apache and it worked. After I finished everything, I can't get anything displayed in localhost. What am I doing womg?

Who: u24
When: October 13th, 2005
Says: email me your php.ini and httpd.conf, i'll see if there's anything obviously wrong with them.

Who: amit
When: November 9th, 2005
Says: Has anyone solved the problem of connecting to mysql database when apache tomcat is configured to serve php pages (requesting this database connectivity)? I've no idea how to configure tomcat to do so.

Who: Me
When: November 14th, 2005
Says: I have a .sql file and i can't execute using .filename.sql.What do i do wrong?
---
from u24:
i'd suggest opening it in mysqlfront, and executing it from there.

Who: email address imagified
When: November 22nd, 2005
Says: Hi

everything works fine



Who: DTS
When: November 23rd, 2005
Says: I am also looking for tomcat php combination setup configuration.

DTS................
http://www.jobs.co.in/

Who: email address imagified
When: January 2nd, 2006
Says: I wanted to use the same mysql and php versions as my host... so I used this tutorial to install PHP 4.4 and MySQL 4.1. I only ran into two problems................

1st Prob -- getting Apache to recognize PHP
Solution -- I had to move the php4apache.dll up to c:/PHP (where I had installed PHP) from c:/PHP/sapi (and obviously change all the 5s to 4s in the tutorial example)

2nd Prob -- getting PHP and MySQL to work together: "Client does not support authentication protocol"
Solution -- (found at http://dev.mysql.com/doc/refman/4.1/en/old-client.html )
in mysql command prompt I used this:
mysql> SET PASSWORD FOR
-> root@localhost= OLD_PASSWORD('mypassword');

Who: who
When: January 5th, 2006
Says: when i try to send emails in php i am geting the error like this..

Warning: mail() [function.mail]: Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in C:Program FilesApache GroupApache2htdocsfirst_mail.php on line 6

i have not installed IIS in my PC do i need to install it to run SMTP Server.My OS is WIndows XP and web server is Apache 2.0
---
from u24:
Yeah, you won't be able to send mail through PHP until you've got an SMTP server set up locally.
I've never set up a local mail server. You'll need to install an SMTP server, I'm not sure if IIS includes one, but I'm sure there are free windows SMTP servers out there. Good luck, tell me what you find.

Who: email address imagified
When: January 21st, 2006
Says: your instructions are great, BUT
i have two problems:

1) i have installed apache 2.x with mysql 4.1.1 n php 5.1.1 , i get these errors:

Access denied for user 'user'@'localhost' (using password: YES) in c:program filesApache GroupApache2htdocsfor mysqlmysql.php on line 3

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:program filesApache GroupApache2htdocsfor mysqlmysql.php on line 7
Access denied for user 'user'@'localhost' (using password: YES)

i understand that your instructions aren't meant for apache 2.x, but all the same any solutions would be highly appreciated

2) This is one of my BIGGEST problems, i have installed free smtp server n as per the instructions kept the codes in the php.ini file as

SMTP = localhost
smtp_port = 25

i have tried to find free smtp servers on the web all in vain, nothing seems to make sense, i just need a smtp server to forward mails using php mail functions. im losing my brains here!

thanks again, any assistance is welcome.

Who: email address imagified
When: February 16th, 2006
Says: Great stuff. Thank you!

Who: Dany winnerzATcashetteDotcom
When: March 29th, 2006
Says: Hello ,

Can I Install Apache Without PHP,MYSQL & To You As Server For Simple HTML & Images Without Any Script? Or Without Any Problem?
I Have Windows XP SP2 Wich Apache Is Good For XP & The Exact Link To Download Please,Thank you
Dany
---
from u24:
yeah, just follow the instruction about but don't install what you don't want.. apache.org should help you. that or google..

Who: email address imagified
When: April 14th, 2006
Says: great site. However, I've found XAMPP from www.apachefriends.org nice as it is a one-time download to get everything, and runs off a simple included installer.

YMMV

Who: email address imagified
When: April 21st, 2006
Says: APACHE CONFIGURATION (WAMP)
Setup Apache on windows 2003 server, tested and it is running. On the LAN, I am able to access apache.

NOW, I need help on how I can access my apache from remote, anywhere through http. Please help.
---
from u24:
looks like a firewall issue, try it without the firewall running; if it works, look at your ruleset.

Who: email address imagified
When: June 20th, 2006
Says: Hi,
After step by step WAMP installation,
I am stuck in following problem:

Cannot start Apache ( 2.2.2 - win2k - php 5) when using line:

LoadModule php5_module "c:/php/php5apache2.dll"
with or without quotes, with diferent paths and similar.

From command prompt php.exe works fine.

Any idea?

Who: email address imagified
When: July 31st, 2006
Says: I get the same error with LoadModule php5_module "c:/php/php5apache2.dll" except I am running XP Pro.

Who: Sparkie
When: August 1st, 2006
Says: I got the same error. Seems that apache 2.2 is not supported currently by php:

Quote:
Apache 2.2.x Support: Users of Apache 2.2.x may use the documentation below except the appropriate DLL file is named php5apache2_2.dll and it only exists as of PHP 5.2.0. See also http://snaps.php.net/

http://uk.php.net/manual/en/install.windows.apache2.php

So you either downgrade apache to v2.0 or wait until php 5.2.x is being released, whenever that may be.

Grz, Spark

Who: email address imagified
When: August 3rd, 2006
Says: On XP home the tutorial does'nt work..
First of some may have trouble with apache because you'll need the php5apache2_2.dll that comes with the latest snapshot.
Secound of, you have to compile php with mysql. Just copying the mysql libraries wont bridge php-mysql alone.. So conclusion is.. If your on xp home, you have more work to do apparently ;(
---
from u24:
interesting. thanks for letting me know.

Who: email address imagified
When: August 6th, 2006
Says: as per the above instruction i have set up the wamp but i need to set up local smtp.

is it possible?
if it is possible please explain?

Sunil Ahuja
---
from u24:
I use the server for testing only so I've never needed to have SMTP - if you did want to have SMTP, I think you'd need to install an email server - search google, there should be a free one around.

Who: email address imagified
When: September 23rd, 2006
Says: Google for XAMPP - it's a great portable WAMP+ distro.

Who: email address imagified
When: October 29th, 2006
Says: Repeated 403 'Forbidden' Errors when using http://localhost/
---
from u24:
your httpd.conf is corrupt somehow. use the default one.

Who: please solve this error [.] [.] [.]
When: October 31st, 2006
Says: How come it show this and not send to mysql?


seconds //connect to DB server $cn = mysql_connect('localhost,root,''); //select the right db $cn = mysql_select_db('calendar'); //prepare the sql query $sql = "INSERT INTO appointment (subject, starttime, endtime) VALUES ('$subject', '$starttime', '$endtime')"; //echo $sql; mysql_query($sql ,$cn); // Show confirmation echo "Your appointment is added to your calendar.
"; // Show link to index.html echo "Go back to the startpage"; ?>

Who: u24
When: November 28th, 2006
Says: you need to wrap the PHP [? and ?] tags (replace [ and ] with angular brackets)

Who: email address imagified
When: December 8th, 2006
Says: What and where do I get the mysql file from I seem to be downloading the self install version where do I get the other version from
---
from u24:
the self install should be fine; search mysql.com if you want an other version...

Who: email address imagified
When: December 9th, 2006
Says: OK got wamp 5 working but still cannot access mySQL I have this on my screen

phpMyAdmin - Error

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

and this in my apache log file

[Sun Dec 10 18:41:59 2006] [error] [client 127.0.0.1] PHP Notice: Undefined variable: mysql_version in C:\wamp\www\index.php on line 179

Can anyone help please
---
from u24:
Are you sure you've moved the dlls to the right place (see above)?

this isn't really a high-volume forum, so don't hold your breath for an answer from someone else!

Who: email address imagified
When: December 27th, 2006
Says: after installing all these i am running my application in IE but its not running.
if i run in Netscape and firefox it run. what is the reason?
---
from u24:
I guess that IE is set up to use a proxy server, or there's some other connection setting that's different. I take it you can access other sites in IE?

Who: email address imagified
When: January 5th, 2007
Says: I have installed Apache, MySQL, PHP according to your instructions and have

tried to test PHP, by creating a new text document with the following content, and named it "info.php":
<?
phpinfo();
?>

Then I opened http://localhost/info.php in my browser and just get the following:



I would be grateful for any help in resolving this. Thanks Phil

Who: email address imagified
When: January 5th, 2007
Says: Sorry the last line showing the result in the browser appears to be missing:

<?
missing line
?>

The browser just displays the missing line from the test document
---
from u24:
resolved via email, but for future readers:
instead of < use the angular opening bracket (usually shift-period) and instead of > use the closing bracket - shift-comma. Just like html.

Who: email address imagified
When: January 12th, 2007
Says: great guide! I have the WAMP package installed on a local test server, and can view everything great from other client IP's. but...

I'm trying to setup my Zend Studio on client machine to connect to the dev mysql server. i keep getting an error that my client ip/host is not allowed to connect to mysql. can you offer any guidance on how to open up mysql to other ip's?
--
from u24:
sounds like a firewall issue. just a guess...
what firewall are you running?

Who: email address imagified
When: April 5th, 2007
Says: I have tried and failed to send mail with the php mail() function. I tried several SMTP servers out there, and nothing seems to work.
I even tried smtp.google.com and smtp.gmail.com.
smtp.gmail.com works fine in Outlook, for example, but in Outlook i can supply it with username, password, and SSL(Starttls).

I am going crazy...i don't know what to try anymore.

Heeeeelp!!!
---
from u24:
sorry, I've never set up SMTP from a windows box before. Try installing a windows SMTP server, and pointing PHP to localhost:25 for SMTP.

Who: neminem
When: May 31st, 2007
Says: Geez, hardly seems worth it... nice article, but it seems like more work than just dual-booting linux, as I've been doing for a few months now - especially now that linux package managers are getting so smart. Getting the AMP part of the LAMP setup for me took about 15 minutes, most of which was noticing that my distro had apache installed by default, but I wanted to be using apache2.

Still, it's nice that you've shown WAMP isn't *that* hard to set up.
---
from u24:
heh, yeah dual-boot is probably the ideal (or single boot linux) but wamp is a nice safe way to get some AMP experience.

Who: email address imagified
When: June 4th, 2007
Says: from 2 days i tried to run my php+mySql+Apache, but always i had info "php_mysql.dll not exist". I look for help to about 50 services, publications...and everybody tell mi only: "copy libmysql to windowssystem32" but ... result was this same: no "php_mysql.dll". Yesterday i spend all night on web-world & i looking for "mysql.so" etc. - and about 3am i find this site. I copy php_mysql.dll to system catalog :0 now everything is OK. Thanks
---
from u24:
glad to have helped out. It's surprising how many people have trouble with it. There must be a lot of crap guides out there.

Who: HI all
When: June 21st, 2007
Says: Any one can send me or point me direction to get Apache 1.3.22. I have followed the website mention above, but I couldn't get this version, version 2.xxx apprear only.
TD
---
from u24:
apache 2 should work fine with this guide.

Who: email address imagified
When: July 4th, 2007
Says: Probably a stupid question, but I'm new to this. If I use WAMP on my desktop and develop a simple web app, will the app run on a remotely hosted LAMP setup?

I know most of you will say "use the same setup," so I'm looking for more valuable feedback/help like "no, and here is why," or "its possible, but here are the potential things to look out for," etc.

Many thanks
---
from u24:
unless you're doing strange things like executing commands via php (system(), exec() etc) then you *should* be OK developing on windows for a linux host - that's how I manage puremango.

Who: Svennetjee
When: July 30th, 2007
Says: Check this: http://www.wampserver.com/
All packed in one setup!
---
from u24:
agreed that wampserver is very good, but you learn more by doing it manually imo.

Who: Barroon
When: December 10th, 2007
Says: I want be designing Web sites, do you think WAMP will be my best option?
---
from u24:
yes :-)

Who: email address imagified
When: January 9th, 2008
Says: Hello, I am new to web development, I decided to go for MySQL,PHP and APACHE, I got the individual set up's, however Apache refused to even begin installing on my system, it begins but then would say that it has been interrupted, and it will then give me the click finish option.I installed WAMP5 succesfully, but when I click the "Local host link",the bowser displays "cannot find page, PHPmy Admin gives the same. Please is there any configuration I need to do, and please is there any help I could get for why the Apache refuses to install

Who: email address imagified
When: January 14th, 2008
Says: good

Who: email address imagified
When: February 18th, 2008
Says: Yeah. RTFM.


Who: email address imagified
When: February 26th, 2008
Says: have setup a WAMp using the software XAMPP.. Its ok , however not able to make the ajax part working. any suggestions ?

Who: email address imagified
When: February 29th, 2008
Says: i have problem with wamp5.1.7
installed in Win Server2003 it working. But clients(win Xp) are not access
Query is it asked user Id and password.
i was give the admin,admin

that is not access so please Souled.
thank you.

Who: email address imagified
When: February 29th, 2008
Says: Same like Scott earlier:
Followed the directions exactly as listed. Have everthing installed and moved to the correct directories on my machine. Edited and changed all files as in your documentation. Moved them to the correct directories. When I get to Now Let's test it to see if everything is working. I get the following error message when doing a net stop apache. System error 1060 has occurred. The specified service does not exist as an installed service. Can anyone offer any suggestions ??

Please help!


Who: mzo
When: March 12th, 2008
Says: please help me!

How to install and connect them:

apache 2.2.8
mysql 5.0.51a
php 5.2.5.32 windows
php install 5.2.5 windows

 Add your comments:
Who / E-Mail:*
Your Comments:*
(php/html will be removed)

Because spammers have targetted me due to my antispam efforts, I'm going to have to ask you to complete this CAPTCHA test before posting.
Learn more about fighting spammers.
 enter text
word above:
If you can't read the word, click here
 
* denotes a required field.
Your email address will be converted to an image to prevent spambots picking it up.
yup, it's a mango.

Scheme:  R G B T