April 19th, 2009
Tutorial : Installing Apache 2.2.11, PHP 5.3, MySQL 5.1.34 & PhpMyAdmin 3.1.4 in Windows Vista/XP
The most recent version of this tutorial has been completely re-written at WebDev Codex.
Learn how to Install PHP 5.3,
To view the latest version, Goto Screencast #1 : Installing Apache 2.2, PHP 5.3, MySQL 5.1 & PHPMyAdmin 3.2 for Windows 7/Vista
If you want to see the screencast of this tutorial, then goto
Screencast #1 : Installing Apache 2.2, PHP 5.3, MySQL 5.1 & PHPMyAdmin 3.2 for Windows 7/Vista
Not everyone would spend money online to buy webspace just so that they can test out how their latest application works, Well… Welcome to Vision Master Designs Blog. This tutorial will teach you to set up a developer environment for PHP/MySQL in your computer in no time.
Index :
- Page 1 : Introduction
- Page 2 : Create Directories & Install Apache
- Page 3 : Install PHP5 & Configure php.ini
- Page 4 : Configure Apache 2.2
- Page 5 : Installing & Configuring MySQL5
- Page 6 : Installing & Configuring PhpMyAdmin
If you are aware of the basics then Click Here to jump below, else read on.
Normally we can view HTML pages on our computer without the need of uploading them to the server, since HTML is a Client Side Language. You don`t need any extra software to view html files, just any browser will do the trick.
But if you want to make your pages dynamic using any Server Side Language (PHP,ASP,JSP) & want to the see the results then you must upload the file to the webserver which supports that language so it can execute the file & return the results on your browser
We can set up a developers environment from which you can create and execute PHP/MySQL scripts by installing the above mentioned applications.
- Apache HTTP Server (2.2.11): The best open source webserver. You need this to turn your humble computer to a powerful webserver to execute your applications.
Direct Download apache_2.2.11-win32-x86-no_ssl-r2.msi
Apache Download Page – Please Download the Win32 Binary without crypto (no mod_ssl) (MSI Installer) – apache_2.2.11-win32-x86-no_ssl.msi~ 4.3MB - PHP (5.2.9) : One of the most powerful web programming languages.
Direct Download PHP 5.2.9 -2 zip package
PHP Download Page – Download the PHP 5.2.9 – 2 Zip package ~ 10MB - MySQL (5.1.34) : One of the best DBMS packages which is free.
The latest version is 5.1.34 which is stable and used in production servers. Although MySQL 5.1 and MySQL 6 are also available as beta releases, they are not used in production servers as of now.
MySQL Download Page – Please download Windows ZIP/Setup.EXE (x86) 5.1.34 ~ 35.2MB - PhpMyAdmin (3.1.4) : Used to manage your MySQL databases directly using your web browser.
Direct Download phpMyAdmin-3.1.4-all-languages.zip
PHPMyAdmin Download Page – Please download the latest release from the 3.x rooster.
The above downloads are compatible with Windows Vista/Vista SP1 (32 bit OS).
May 18, 2010 at 1:26 am
Thanks so much for the tutorial.
May 15, 2010 at 5:23 pm
please i was not able to install the mysql successfully, please anyone there? help!
May 10, 2010 at 9:10 pm
Thanks for the tutorial. It was easy to follow and set everything up just great.
April 18, 2010 at 11:37 am
Hola, excelente tutorial, el mas completo que encontré.
Me fué de mucha ayuda.
Gracias
April 16, 2010 at 5:42 am
Avoid Spam E-mail Offers
April 8, 2010 at 10:15 am
I follow the tutorial of this site but when I want to start and stop the apache server it's give me this error:
the request operation has failed
so what the … should i do?
I am really got tired because I RTFM every day but still i can not do it
by the way i use win 7 intel i7 thanks
April 6, 2010 at 8:32 pm
How do you open up a port in Windows 7 so I get to browse my PHPMyAdmin? I can't even do it cross the room on another PC…
April 1, 2010 at 9:27 pm
thanks a lot ! Everything works fine !
March 12, 2010 at 8:37 pm
Thx for the tutorial tho.
when I configure httpd.conf file,
I am not able to save changed file.
I don't know why, it says 'access denied'
Im using 64bit CPU, does it matter?
please reply me anyone..
true_affection@hotmail.com
thx everybody
March 1, 2010 at 9:39 pm
thx for the tutorial. i just found a way to save the httpd file easily in vista. it didnt allow me to save directly. but then i
saved it on the desktop and then dragged it into the folder. it asked me for admin permission. pressed ok and its done.
February 21, 2010 at 11:55 am
Nice user friendly tutorial. Thank you for that. I succesfully installed Apache – It works!
However, when i configure PHP, the browser is blank – nothing is shown in here – my Apache Service Monitor says Apache/2.2.14 (Win32) PHP/5.2.12 in the bar in the bottom, but I can't get it to show the phpinfo() in the browser…
Any suggestions? Thanks in advance
February 16, 2010 at 10:35 am
it's the best tutorial ever in my life……. thanks so much. But, could anyone give me the idea how to make the apache available within network, at this moment i can run php/html files only form my computer.
February 16, 2010 at 11:13 am
Great tutorial!
My fault, but I had a really hard time before finding out that my only problem was the extra space (which I didn’t notice) between the < and ? characters in the index.php code. d'uh
February 6, 2010 at 2:14 am
also try changing the host line from = 'localhost' to ='myserver.dev' .. That finally got me up and running.
February 5, 2010 at 11:08 pm
The second problem (the one with the login ) just change the password in that file and it will work
February 5, 2010 at 11:03 pm
the last error on phpmyadmin is because is a space between <? delete that space and everthing will be fain
January 24, 2010 at 9:16 am
Okay, I installed Apache using an Administrator account in WinXP, works fine as an Administrator, however the service fails when I'm logged on as a User. Any suggestions?
The service is using the LocalSystem account…
Thanks,
Bob
January 3, 2010 at 9:31 pm
i did exactly as shohwn but when i go to myserver.dev the sql part is incomplete the second column is not there but mysqli part is full
December 24, 2009 at 2:04 pm
thnx for the tutorial .But when I am trying to restart apache..it fails
i followed start>programmes>apache http server 2.2>configure apache server>test configuration IT IS GIVING ME FOLLOWING ERROR
"syntax error on line 118 of C:Program FilesApache Software FoundationApache2.2conf.httpd invalid command PHPINIDIR,perhaps misspelled or defined by a module not included in your server configuration…
PLZ HELP !!
December 16, 2009 at 6:28 am
Very well written instructions…Thank you!
December 16, 2009 at 6:00 am
Great tutorial btw
THANK YOU VERY MUCH!!!
December 16, 2009 at 5:56 am
Replace "< ?php" with "<?php"
December 9, 2009 at 12:12 pm
Hello
I Got A Problem,
when i;m goin to the link – http://myserver.dev/
the website sayed:
Forbidden
You don't have permission to access / on this server
How can ik solv the problem?
December 2, 2009 at 10:44 pm
I have gotten to install mysql and when I type http;//www.myserver.dev all that comes up is the php code that is in my index.php file. Using apache 2.2.14 with php 5.2.11
December 1, 2009 at 9:09 am
i am also have same issue like moten and maz !!
it's an error on top
"
< ?php //config.inc.php $cfg['blowfish_secret'] = 'abc'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ /* * Servers configuration */ $i = 0; /* * First server */ $i++; /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; /* 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'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'root'; $cfg['UploadDir'] = ''; $cfg['SaveDir'] = ''; ?>
"
when i try to log in it goes to the error page displaying same error …
thanks
November 29, 2009 at 12:16 pm
I would like to appreciate and thanks for your great effort to make us know how to install apache, php and My sql. This is the best tutorial I ever found for vista OS. I was trying install all of this for last three months, when I find your page I done it in a day. Thank you so much
November 24, 2009 at 3:32 am
Likewise would also like to add that whenever I go to http://www.myserver.dev
I only get 2 links: index.php.text and pma/
February 16, 2010 at 5:47 am
Hi bob, Check the file extension for index.php. It looks like you left index.php.text
November 24, 2009 at 2:53 am
Have the same issue as Morten and Maz…any fix to this?
November 18, 2009 at 10:57 pm
Everything works fine except phpMyAdmin.
It shows everything as it should, but at the top of pages (both the main page and the sidebare at the left) it shows a lot of php code.
The code it writes is the following:
< ?php //config.inc.php $cfg['blowfish_secret'] = 'abc'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ /* * Servers configuration */ $i = 0; /* * First server */ $i++; /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; /* 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'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'root'; $cfg['UploadDir'] = ''; $cfg['SaveDir'] = ''; ?
Hope someone can help me.
Besides that, its an awesome guide!
Morten
November 22, 2009 at 11:03 pm
I am having the same issue. I also cannot login for some reason. If you find the solution to this, please email me the solution if you do not mind.
March 22, 2010 at 9:24 pm
I had the same problem and in some post below "Resolver" said: replace < ?php with <?php, I tried with "config.inc.php" file and it work's.
November 13, 2009 at 7:20 pm
Just for those who might be encountering the same issue;
Solved the dll problem just by switching to an older version of PHP.
Instead of PHP5.3, now I am using PHP5.2.9.
The new problem is with logging into phpMyAdmin.
I used the script given above for the page. But when trying to login, I get the error below:
#1045 – Access denied for user 'root'@'localhost' (using password: YES)
Tried using pwd YES on the page instead of root, still did not work.
Any body else had the same issue ? If so how did you fix it?
Thanks,
-Elham
November 12, 2009 at 4:41 am
some additional notes on the details of my installation:
Vista OP
Apache Server 2.2.14
PHP 5.3
mysql essential 5.1.40
Have not got to the installation of mysql yet.
June 4, 2010 at 4:55 pm
cannot determine the server's fully qualified domain name, using 115.242.214.21 for ServerName…………………. pls help me with the above error message tat appears wen i want to start/restart apache http server ….. i have been stuck with tis for the past 2 days ……….. pls pls help me
November 12, 2009 at 3:42 am
Hi,
Followed all the steps mentioned so far.
1st problem encountered was the missing php5apache2_2.dll from the zip file. Downloaded from some site.
Then I tried to restart the server.
Unfortunately Apache does not load it.
Any idea how to fix this?
Checked the path. All is ok.
Any help would be appreciated.
Regards,
-Elham
November 8, 2009 at 3:38 pm
In order to see the picture, you will need to use Google Chrome Browser. You can dowload and install it free. just google it.
GK6
October 30, 2009 at 3:55 pm
hello
THANK YOU for the best tutorial i found
i just got a problem: after i follow how to "install" phpmyadmin and try it in the browser shows me :"phpMyAdmin – Error
Cannot load mysql extension. Please check your PHP configuration. – Documentation"
can you help me with this?
Note:
i'm quite noob
and phpmyadmin version is:" phpMyAdmin-3.2.2.1-all-languages"
November 29, 2009 at 1:56 pm
hey,
it happens that I got just the same problem. If you´ve got solved it, please send me e-mail.
thanks
October 29, 2009 at 10:22 am
I followed the steps to make the installation over Windows 7, and everything works perfect. I used this tutorial before over windows Vista and was some problems, but finally worked with some adjustments, but over windows 7 everything went smothly. thanks
October 28, 2009 at 7:21 am
Hey just one question, I did everything I had to, step by step, but when I checked the http://myserver.dev/ the mysql and mysqli sections dont show up, any idea as to why this might be?
thank you.
October 28, 2009 at 7:18 am
Hey, Just one question, I did everything that I was asked to in this tutorial, step by step. but then when I checked http://myserver.dev/ the mysql and the mysqli sections did not show up? any ideas why this might be?
thank you.
October 28, 2009 at 3:43 am
Thanks a lot!!! I had been breaking my head with installing PHP + Apache + MySql on Vista for past 3 days and you saved my life here!! Thanks a ton!!
October 17, 2009 at 4:25 am
please help me to solve this problem. i have installed apache and php and mysql. apache and php is working fine. mysql also working i can create database and all but in phpinfo file is not display mysql enable. how do i do that? I followed all the instruction that in the web site but still i couldn’t fix the proble.
October 15, 2009 at 12:11 am
Hi,
Just wanted to say that your guide worked brilliantly. I followed every step accuratly using the newest versions of every software and it worked nicly. I had to remove the spacing between the < and php that was erronously inserted in two of your php-code-boxes, but once I figured that out the rest was pretty much like a walk in the park. Very thankful for this guide!
October 14, 2009 at 11:08 pm
hello mic,
i’m having problem with my PhpMyadmin…
i cannot login inside…there is an error :
#1045 – Access denied for user ‘root’@'localhost’ (using password: YES).
what this mean mic? please help me?
i enter the username and password as a root…
October 14, 2009 at 6:16 am
Followed the setup process for Apache and PHP so far
I restart Apache and get DocumentRoot C:/~public_html doesn’t exist
and make_sock: could not bind to address 0.0.0.0:80
I had Apache working fine this afternoon by a straight install but couldn’t get it to pair up with PHP. Now I’m back to square one and 12 hours older. Any ideas?
October 11, 2009 at 11:55 am
” ?php//index.php phpinfo(); ? ” but with a before and after it.
October 11, 2009 at 11:53 am
October 11, 2009 at 11:50 am
Hi, thanks for the article!
Just a problem here, I had no problem until after configuring mysql, i pointed to “http://myserver.dev/”
and instead of the page you displayed, it shows
“”
After that, I went back to try “http://localhost/”, it worked fine at first, but now it shows
“” as well.
Where did I go wrong?
October 11, 2009 at 11:52 am
Er.. why doesnt that shows up. Okay it shows
” ” both times, but only one question mark at the end.
September 29, 2009 at 1:36 pm
Michael great tutorial! Everything work for me on Vista.
Bob K, if you still have the same issue here is the solution:
If you used copy/paste for code from tutorial you only have the error in your code(i know that you’ve seen exactly the same code from tutorial) but you must retyped every ” and ‘ ‘ in your file because your regional settings may deffer from text on Web.
Let me know if this is solution for your problem
P.S Sorry falks for my bad english, I came from Serbia so the english isn’t my primary language
September 19, 2009 at 10:42 am
Thanks mate. This tutorial was excellent!!!
September 15, 2009 at 9:21 pm
I just finished with the MySQL configuration tutorial, but I get
“Forbidden
You don’t have permission to access / on this server”
when I point to it in “http://www.myserver.dev” in the browser. Please Help
August 28, 2009 at 6:19 am
Thank you for creating this!
I dreaded reading the books. Usually it’s too much to go through.
You have answered my questions, 1) how do I set up php and apache and 2) can I start coding right away? In other words, your tutorial was direct and to the point. I will admit that after typing the index.php, I immediately tried to do a hello world without finishing the apache configuration. It gave me the 404 error. index.php only lets the reader know that php was found. Finish the apache and php configuration first before ambitiously trying to write php web pages.
For now, steps 1, 2, and 3 is as far as I want to go. I just want to understand how the steps go. Too many times, the setup is already done for me. Now I want to know how it’s done. I will complete steps 4 and 5.
August 25, 2009 at 4:45 am
Where are you getting the file php5apache2_2.dll? It was not in the ZIP file when I downloaded the latest 5.3. Whenever I put that line in my httpd.conf file, apache won’t start, says it can’t find the file. I have tried using an Alias, absolute path to, and it can’t find it (originally because it wasn’t there), but i downloaded it from the web and still doesn’t see it. What is going on?