Tutorial : Installing Apache 2.2.11, PHP 5.3, MySQL 5.1.36 & PhpMyAdmin 3.2 in Windows 7/Vista/XP
This tutorial will teach you how to install and configure Apache 2.2.11 + PHP 5.3 + MySQL 5.1.36 and PHPMyAdmin 3.2.0.1 for Windows Vista & Windows 7 in a step by step manner. There is also a screencast available.
This tutorial is a textual version complementing “Screencast #1 : Installing Apache 2.2, PHP 5.3, MySQL 5.1 & PHPMyAdmin 3.2 for Windows 7/Vista”
The Tutorial is the modified version found at Vision Master Designs.
Index :
- Step 1 : Install Apache
- Step 2 : Install & Configure PHP 5.3
- Step 3 : Configure Apache 2.2.11
- Step 4 : Testing our Apache + PHP
- Step 5 : Installing and Configuring MySQL5
- Step 6 : Installing and Configuring PhpMyAdmin 3 Optional
- Step 7 : Making Windows recognize myserver.dev Optional
The Pre-Requisites :
- 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.
Download Apache 2.2.11 (with no mod ssl) (8827) - PHP 5.3 – Download PHP 5.3.0 (VC6 Thread safe) (8637)
- MySQL 5.1.36 – Goto Download page
- PHPMyAdmin 3.2.0.1
PHPMyAdmin Download Page | Direct Download PHPMyAdmin 3.2.0.1 (2476)
The above downloads are compatible with Windows 7/Vista/Vista SP1 (32 bit OS).
Before starting this tutorial. Please Turn off UAC (User Access Control) in Vista. Trust me you will get fed up on how many times it`ll popup while installing this environment.
Step 1 : Install Apache
- First create a
New FolderinC:\and name it asserver. - Start the installation, and follow the onscreen instructions as shown in the screencast.
The settings for Server Information are given below.
Apache 2.2.11 Settings
- Choose Custom Installation and specify the install path as
C:\server\apache\ - Once Installation is complete, verify the installation by clicking on the Apache Icon in the taskbar, as shown in the screencast. You can also verify your installation of Apache by opening http://localhost/ in your browser.
- Congratulations for a successful installation of Apache. We still have to configure Apache, we will do it in the coming steps.
STEP 2 : Install & Configure PHP 5.3
-
Extract PHP package
Now to install PHP5. Open the zip file & Extract all your files to
C:\server\php. Navigate toC:\server\php -
Rename php.ini- file
Search for the file,
php.ini-developmentand rename it tophp.iniEDIT php.ini
Open up
php.iniusing any text-editor. (Notepad, Wordpad, Preferrably Dreamweaver). There are 2 edits in this file -
Edit 1
Find
extension_dir = "./"and replace it with (Please note the slashes)
extension_dir = "C:/server/php/ext"Edit 2
Now in the following edit, you just have to uncomment (by removing the “; – semicolon”) from the extension to activate it. So here are the extensions to be uncommented. Search for each one them and remove the semicolon
;
;extension=php_gd2.dll
;extension=php_mbstring.dll
;extension=php_mysql.dll
;extension=php_mysqli.dll
The First extension enables the Image GD library of PHP.
The Second enables mbstring.
The Third and forth enables us to use MySQL database.Save the php.ini file.
-
Adding PHP Environmental Variables in the System path
Great ! Now we have to add tell the computer to start php everytime the computer reboots. So, Navigate to your
Start->Control Panel->System->Advanced System Settingsthen go to the advanced tab, Click on theEnvironmental Variablesbutton, then scroll down in system variables to findPATH, Edit it Add the following Code to it, as shown below in the image,C:\server\php;
PHP Environmental Variables
- You MUST MUST MUST reboot a windows box after setting the Path variable (step 2). If you move on past that point without rebooting – logging off is NOT enough – apache will have trouble finding your mySQL extensions.
- Finally, Step 2 is over !. Now we have PHP configured. Lets move on to configuring Apache.
STEP 3 : Configure Apache 2.2.11
- Now navigate to
C:\server\Apache\conf
Edit httpd.conf
Some users had reported that they weren`t able to edit httpd.conf in VISTA using Notepad. Try using Dreamweaver or any other editor to edit the *.conf files. If you are still not able to open httpd.conf file in any text editor, you can try the following solutions
- Try different text editor
- Stop Apache server from the taskbar and then try to edit
- You should have administrative previliges. Try disabling UAC
- If none of the above work. Reboot your computer in safe mode and then try to edit httpd.conf
The above is applicable for all *.conf files
Okay, brace yourself, we got 5 Edits in this file. No big deal, pretty simple search and replace text.
Edit 1
Search for
#LoadModule rewrite_module modules/mod_rewrite.so
Replace with
LoadModule rewrite_module modules/mod_rewrite.soEdit 2
Add the following below the previous edit
#PHP5 LoadModule php5_module "C:/server/php/php5apache2_2.dll" PHPIniDir "C:/server/php"Edit 3
Search
AddType application/x-gzip .gz .tgz
Add the following below the searched line
AddType application/x-httpd-php .php AddType application/x-httpd-php-source .phpsEdit 4
Search for
DirectoryIndex index.html
Replace with
DirectoryIndex index.html index.phpEdit 5
Search for
#Include conf/extra/httpd-vhosts.conf
Replace withinclude conf/extra/httpd-vhosts.conf - Now navigate to
C:\server\Apache\conf\extra
Edit httpd-vhosts.conf
-
Replace all the text inside with
<virtualhost *:80> DocumentRoot "C:/Server/www/myserver.dev/public_html" ServerName myserver.dev ServerAlias www.myserver.dev <directory "C:/Server/www/myserver.dev/public_html"> AllowOverride All Options Indexes FollowSymLinks Order allow,deny Allow from all </directory> </virtualhost>
-
Restart the Apache Webserver
If you have followed perfectly you`ll see that Apache has restarted perfectly.
Step 4 : Testing our Apache + PHP
-
Create Directories to store your web files
- Firstly lets make the required Directories. Create a
New FolderinsideC:\server. - Inside the
C:\serverfolder, create folder calledwww - inside
C:\server\www\createmyserver.dev - and then finally create
public_htmlfolder inside yourC:\server\www\myserver.dev\
Follow this structure
C:\server\www\myserver.dev\public_html\
This is where you will be putting all your html,script etc files to be accessed by your webserver. - Firstly lets make the required Directories. Create a
-
Create index.php
Open up notepad, type in the following code and save the file as
index.phpinsideC\:server\www\myserver.dev\public_html\as shown in the above picture.<?php //index.php phpinfo(); ?>
Please note the file name, it is
index.php. Many a times, Notepad saves it asindex.php.txt, while saving, don`t forget to mention the type as All Files, this way Notepad will save it asindex.php.
STEP 5 : Installing and Configuring MySQL5
- Lets start by unpacking the zip & start the installation. Select Typical, click Next
- Click Next after reviewing where you are installing
- Skip the Sign-up.
- Install SQL, Now time to configure SQL. Its pretty simple, if you follow the onscreen instructions.
- Now just follow the following images.
Enable TCP/IP Working and PORT no
- Finally click on Execute and let mysql configure everything.
During the MySQL installation and configuration,if you have missed any step or have not configured properly, then you can run the MySQL Server Instance Config Wizard which can be accessed via ‘Start->All Programs->MySQL’.
*If MySQL Instance Wizard does not complete the final step, reboot your computer and configure again.* -
Test MySQL along with Apache+PHP
Now to test whether MYSQL & PHP along with APACHE are working fine, restart the webserver, i.e click on the apache icon in your taskbar (near time in the taskbar/startbar) and restart the webservice.
After it has restarted (green play icon will be displayed), point your favourite web browser to http://localhost.
PHP 5.3.0....nice
If you are able to see the above page, then you have successfully configured Apache+PHP5. To verify whether MySQL5 has been installed, scroll down the page until you come across mysql & mysqli heading as shown below.
mysql and mysqli are extensions for MySQL
- Woohoo ! Congratulations ! You have successfully installed Apache2.2.11+PHP5.2.9+MySQL5.1.34 on your system. *sigh*
STEP 6 : Installing and Configuring PhpMyAdmin 3
-
Extract the PhpMyAdmin 3 package
This is an optional ! You can use your webserver without it as well.
Extract all the files inside thephpMyAdmin-3.2.0.1-all-languages.zipto aC:\phpmyadmin. Now navigate insideC:\phpmyadminyou`ll see another folder namedphpMyAdmin-3.2.0.1-all-languages(even if the name is something else), rename this folder topma. Cut this renamedpmafolder and paste it insideC:\server\www\myserver.dev\public_html - Now If you have followed everything properly, when you point your web browser to http://www.myserver.dev/pma/index.php you will see a login screen or the following screen.
If you get the login screen, the username | password isroot | root.
STEP 7 : Making Windows recognize myserver.dev Optional
Editing hosts file
Navigate to C:\Windows\System32\drivers\etc
Open up hosts in notepad/wordpad/dreamweaver any text editor and add the following
127.0.0.1 myserver.dev 127.0.0.1 www.myserver.dev
Conclusion
Thank you for reading this tutorial, hope you guys enjoyed 
There is a screencast based on this tutorial, so do check it out Screencast #1 : Installing Apache 2.2, PHP 5.3, MySQL 5.1 & PHPMyAdmin 3.2 for Windows 7/Vista
If you are having any trouble, feel free to post a comment.
Enjoyed the Article ?
The tutorial works. I changed the dir for my files to C:\htdocs. http://localhost/ shows
my php screen.
Dreamweaver CS5 doesn’t like the virtual server. Live View show error server not found and
the browser says “NetError Page”.
How do I set up my server non-virtual? Nothing seems to work (except this tutorial) and
can’t find help on the web.
Using mysql-workbench-gpl-5.2.25-win32.msi and php-5.3.2-Win32-VC6-x86.zip
Sorry,
Using httpd-2.2.15-win32-x86-no_ssl and php-5.3.2-Win32-VC6-x86.zip. At this point I'm not doing anything with MySQL.
I originally used these same tutorials to download and install Apache 2.2.9, mySQL 5.0.67, php 5.2.6 and phpMyadmin 2.11.9
I recently upgraded the php to php 5.3 and have hit problems – basically when I run a script which issues a mysql_connect() or @mysqli_connect command it fails with the error:
Warning: mysql_connect() [function.mysql-connect]: [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306) in C:Serverwwwmyserver.devpublic_htmlpost_message.php on line 17
My questions are:
1. should I be using the most recent versions of Apache and My SQL in conjunction with php 5.3?
2. can I simply overwrite the existing installed versions or do I have to uninstall and then re-install?
3. crucially – will my doing all this resolve the problem I have just reported?
I look forward to reading any helpful comments that people can offer.
Stuart
Hi Stuart,
I have similar problem, if you do get the solution ,can you please post it here.
Warning: mysql_connect() [function.mysql-connect]: [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306) in C:serverwwwmyserver.devpublic_htmlmysqltest.php on line 2
Warning: mysql_connect() [function.mysql-connect]: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in C:serverwwwmyserver.devpublic_htmlmysqltest.php on line 2
Fatal error: Maximum execution time of 30 seconds exceeded in C:serverwwwmyserver.devpublic_htmlmysqltest.php on line 2
HiStuart,
I found the solution, is the server ip address and port number as seen below, is what you should use in the connection. It works
<?php
// we connect to localhost at port 3306
$link = mysql_connect('127.0.0.1:3306', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
PHPMyAdmin problem – look at Step 2 Edit 1.
Did you make the change but forget to uncomment the line for the extension directory in php.ini? None of the tutorials mention it explicitly, but it would be a very simple and hard to find mistake to make…
Thanks a lot.. works for Apache 2.2.15, PHP 5.3.2, MySql 5.1.48, Phpmyadmin 3.3.3 also.. windows 7
thanks a lot
You people realy done a great job……………
I m very thankful to you all
but i am facing aproblem
i have installed and configure php,mysql and apache succesfully
but when ever i place php files in the directory
C:serverwwwmyserver.devpublic_html
and try to open it in the browser the whole code is seen in place of desried result
i am very pleased if u people please help me out
thanks for all, it's great
Gracias por el Post fue de mucha ayuda. Thank you
Ok,
I carried on from the above and I like many others, got mysqlnd BUT NO mysql or mysqli. A good few people here seem to have had this problem too. I checked the mysql status from the command line using C:mysql -u root -p and the server was running, so appeared not to be an SQL problem. Please check the PHP summary at the top of the PHP page to see if a config file is loaded! The file should be C:serverphpphp.ini and if this is not appearing then the mysql entensions are never going to be loaded.
My problem surrounded the renaming og the ini-development file. Using notepad, something was clearly going wrong, despite being careful to rename the file first (right click->rename in windows explorer, then carry out the edits. It simply didn't work for me, so I opened the php.ini-development file with notepad first, then edited it, then saved it as php.ini REMEMBERING TO CHANGE the file type to "ALL FILES" (or it wouldn't work) AND THEN DELETING the old ini-development file!!! Then I simply restarted apache and it all appeared on the PHP screen. I was pulling my hair out for hours. Good luck everyone! Please post yopur own troubleshooting stories to help others, I wouldn't have been able to get it running without some of the comments posted here, and the tutorial itself of course! Thanks again!
Hi Mike and everyone,
Firstly a big thanks to the author! I tried following a tutorial from a book and it failed at the first hurdle!
It took me a while to get this going on Windows 7 myself (I still haven't tested the MySQL bit, just as far as the PHP screen, but I wanted to post my progress so far in case it helps anyone), so don't despair everyone, it is probably something simple. The problems I had were as follows:
1) didn't remove the semi colon (comment) from in front of <extension_dir = "C:/server/php/ext"> in php.ini
2) kept getting "it works" screen instead of PHP screen when pointing towards localhost, this was fixed by editing the hosts file in C:WindowsSystem32driversetc. You do need to remove the comment '#' from in front of <127.0.0.1 localhost>. It simply wouldn't work for me unless I did this. Windows initially tried to deny me (as administrator) permission to edit this little file for some reason, even though the admin had edit rights on the file! I simply gave edit rights to a normal user for a few minutes and it accepted the edit then-weird!!
3) Kept getting "index of" instead of PHP screen, I had indeed saved the php file with a .txt extension, despite making sure not to! I initially saved it as index.php.txt and the text editor would not show the .txt extension (sneeky!) but I was suspicious and so created a new file and deleted the old one…lesson: BE ABSOLUTELY SURE that you select "all files" when you create that little file, or IT WILL NOT WORK!
Ok, now to test the MySQL part, thanks again to everyone for posting and especially the author: I also need this set up at home to practice for my new job
I have now tried to use mysql_connect() in this web page and get the error
Parse error: syntax error, unexpected T_VARIABLE in C:serverwwwmyserver.devpublic_htmljokelist-2.php on line 12
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Our List of Jokes</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
</head>
<body>
<h1>Richard's Jokes Aren't funny Are they?</h1>
<?php /* Connect to the database server */
MYSQL *mysql_init(MYSQL *mysql)
$dbcnx = MYSQL mysql_connect(MYSQL *mysql, const char 'localhos't, const char 'root', const char 'mypasword');
if (!$dbcnx) {
exit('
Unable to connect to the ' .
'database server at this time.
');
}
/* Select the jokes database */
if (!@mysql_select_db('ijdb')) {
exit('
Unable to locate the joke ' .
'database at this time.
');
}
I have the same error with that file, any solution?
I am a newbie and have a very fundamental question. I followed the above steps and managed to get an almost perfect installation. My question is
"In which folder should I start building my site. I put the site in public_html folder but php is not working working properly. The ending tags of php ?> are showing at the end of echo command.'
What should I do?
Thanks in advance.
Regards
SK
I get the error Fatal error: Call to undefined function mysql_connect(); what have I not configured, can you help
when i add this sentences
#PHP5
LoadModule php5_module "C:/server/php/php5apache2_2.dll"
PHPIniDir "C:/server/php"
the apache server doesn't start any can help me????
I had this same problem, just shut the server down completly, then start
it back up
Thanks for giving such a useful tutorial. but I have problem in connecting mysql & php.
My apache & Php are working fine but php is not connecting to mysql.
Mysql is also running fine.
I am giving localhost, root & the password which I enter while connecting to mysql.
But no connection is made.
The ; is also removed from the php.ini file.
Please help me
When I go to load up http://localhost/pma I type in the username and password but then after the login, the page is blank. Does anyone know if this is a bug or a quick fix? Thanks
man !! this is nice….i have never read a tutorial regarding this without having an error in the end. thanks
That's really excellent tutorial, following which i'm able to configure the whole environment easily without confusion. that's the best tutorial i've seen till now. thanks for your share!
thank you, worked great! i would only mention that users running 64-bit windows 7 should install 64-bit mysql for easiest setup. there are work-arounds for installing 32-bit mysql, but 64-bit installs and functions well. everything works works fine with my 32-bit apache, 32-bit php and 64-bit mysql install on my 64-bit w7 machine.
This is an awesome tutorial. Best explanation yet, AND IT EVEN WORKS!
Thanks for the tutorial. I was struggling to get my PHP working and this solved it!
Thanks for the help. Made it easy for me to install AMP.
thanks. it help me a lot…
Hi,
I didn´t find the version (exactly) of the files that you made reference, I got:
apache httpd-2.2.15-win32-x86-no_ssl
mysql-5.1.46-win32 (installer fromhttp://www.mysql.com/downloads/mysql/)
php-5.3.2-Win32-VC6-x86
phpMyAdmin-3.3.2-english
I did exactly what the tutorial says but in the end I have two problems:
1.- In the MySQL test doesn´t appear the same second windows like you (mysql and mysqli are extensions for MySQL, I got mhash and mysqlnd)
2.- Could be from the same reason, when I did the phpmyadmind test appears: Cannot load mysql extension. Please check your PHP configuration
So what can I do man, please I need some help
Excelente tutorial ,sir
i follow step by step but i have a problem "the requested operation failed".
pls clear my mistake
Like one of the other posters above, I was getting a "blank page" problem on any local sites using the MySQL engine (such as phpmyadmin) until I edited my hosts file (/system32/drivers/etc/hosts) to uncomment the following line:
# 127.0.0.1 localhost
Hope that helps anyone who spent as long banging their head on the wall as I did
outstanding tutorial
have spend many hours trying to acheive this configuration using alot of other tutorials and was unable to get it working.
the extra steps this tutorial showed but were not mentioned in all the other stuff out there are
http.conf
AddType application/x-httpd-php-source .phps
php.ini
extension=php_gd2.dll
extension=php_mbstring.dll
extension=php_mysql.dll
extension=php_mysqli.dll
fantastic thanks again
after all these changes i still get this : “http://localhost/pma/index.php?
token=3d73cfcc071839a3126274b613f493f4″ anyone with an idea of how
to sort out this ? i still use localhost and htdocs i dnt implement the virtual
hosting mode.thanks in advance is been 2 days runnning trying to solve
this blank page of pma(phpMyAdmin) after login
This is an excellent guide and made setting up my new Win7 laptop a breeze! Thank you for an excellent guide!
I know it has already been posted many times but this was just the help I needed It all worked and even on XP. Thank you so very
windows vista or windows 7 specific issue! The system does not seem to understand localhost without a host entry. I spent hours trying to debug this silly issue, so hope this helps someone! If you do not add the entry then using 127.0.0.1:3306 seems to work.
C:/Windows/System32/drivers/etc
uncomment the # 127.0.0.1 localhost
will see like this:
127.0.0.1 localhost
Great work man
it's all good .
Thank you so much. This has been causing me grief for weeks… People like you (and those posters who added information) are the real value of the internet.
Thanks a Bunch!
i got a problem with my PhpMyAdmin. The web browser loaded the login page whit error
Cannot load mcrypt extension. Please check your PHP configuration.
can't someon help me
Hi,
after the mysql installation, the localhost page only shows "it works!" but not the page it's suposed to… what might be the problem ?
thanks in advance
Great tutorial. Thnaks. I had problem swith configuring all these things basinf on XP settings.
Thanks a zilion for this wondefull tuto !!
for those who gets the following with PhpMyAdmin : "#1045 – Access denied for user 'root'@'localhost' (using password: YES). ", refer to the password you have entered in step 5 (installing MySQL5), the password used during the install in the appropriate dialog MUST BE : root (that's the psw used when you log PhpMyAdmin; otherwise, used the psw from your install); I have lost many time with this.
Cheers,
Domi @ gosymbian.com
OMG this is the best tutorial that anyone can come across , I have checked and tried the others and failed to install sucessfully but this one is a cracker!!
Well done!!!
Thank you for a great tutorial. It's the best I've seen, and I've looked at a lot for the past week.
I've used:
apache_2.2.14-win32-x86-no_ssl.msi
php-5.2.12-src.zip
mysql-5.1.43-win32.msi
Ultimately, if I can't get MySQL working well through PHP, I've wasted a lot of time. I gotta have that.
But, no matter what I do – moving php_mysql.dll and php_mysqli.dll, changing the lines in PHP.ini, adding IIS and configuring it carefully, etc., etc. – I just can't get PHP to load MySQL.
My http://localhost is working well with PHP files, but the configuration page does not include the MySQL sections.
So, when my PHP files try to connect to MySQL, they always fail.
Please help me overcome this last block to a good installation.
Many Thanks!
when start up pc seven warring:c:ph5php_gd2.dll , c:ph5php_mbstring.dll , c:ph5php_mysql.dll , c:ph5php_mysqli.dll , c:ph5php_gd2.dll , c:ph5php_mbstring.dll , c:ph5php_mysql.dll , c:ph5php_mysqli.dll
how can solve this problem ,please help me…
when start up pc seven warring:c:ph5php_gd2.dll , c:ph5php_mbstring.dll , c:ph5php_mysql.dll , c:ph5php_mysqli.dll , c:ph5php_gd2.dll , c:ph5php_mbstring.dll , c:ph5php_mysql.dll , c:ph5php_mysqli.dll
how can solve this problem ,please help me…
Thank you for this page you wrote! i install apache+php+mysql !
when i send a mail from php script the following error:"Warning: mail() [function.mail]: Failed to connect to mailserver at "PHP_INI_ALL" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() "
how can solve this problem please reply…..
Actually I was able to find my answer. Changing the following in the phpMyAdmin configuration file:
$cfg['Servers'][$i]['host'] = ‘localhost’;
to this:
$cfg['Servers'][$i]['host'] = ‘127.0.0.1′;
worked.
My question is, why did I have to change this information?
I had the problem with the blank page for phpMyAdmin under win7 and the:
$cfg['Servers'][$i]['host'] = ‘127.0.0.1′;
solve the problem
I was fortunate to stumble upon this tutorial. Everything worked like a charm, except for the final step. When I go to pma and login with "root" and "root" for the UN and PW, the resulting page never loads.
Thanks a lot…… finally worked…
If you want to access phpmyadmin from every "virtual server" in your apache config without the need of copying the phpmyadmin folder to every dir do this:
Download phpmyadmin
Save it to say C:server extract it so that you have a map called phpMyAdmin within that directory
open apache's http.conf
find:
<Directory />
Options FollowSymLinks
AllowOverride None
Order deny,allow
Deny from all
</Directory>
below it add:
<Directory "C:/server/phpMyAdmin">
Options Indexes FollowSymLinks
AllowOverride None
Order allow,deny
Allow from all
</Directory>
find:
# Alias /webpath /full/filesystem/path
below it add:
Alias /phpmyadmin "C:/server/phpMyAdmin"
close the file, restart apache.
open:
C:WindowsSystem32driversetchosts
add for example:
127.0.0.1 http://www.testserver.com
127.0.0.1 http://www.testserver.nl
if you have multiple virtual hosts configured in apache then you can use phpmyadmin from every host.
Example:
localhost/phpmyadmin/ will work
myserver.dev/phpmyadmin/ will work
http://www.myserver.dev/phpmyadmin/ will work
http://www.testserver.com/phpmyadmin/ will work
http://www.testserver.nl/phpmyadmin/ will work
greetz,
a dutch man
hi people i just do everything well, but when i try to open phpMyadmin i have a problem, i put root in username and in password, but apeears #1045 – Access denied for user 'root'@'localhost' (using password: YES).
need help
cumps
Hi,
I am able to install every thing correctly which can be confirmed by
running phpinfo(); but when ever I try to make connection with MySql
using php code I get httpd.exe error. Any suggestions ?
thanx vo this tutorials
^_^
i have done as rusty has suggested yet i am still getting a blank page.
http://localhost/pma/index.php?collation_connection=utf8_general_ci&token=dc808737599bba34c11147e6ca4a6035
what am i doing wrong?
help needed urgently! thanks guys!
hussein i can send you the files if you like. where would you like me to send it to?
is your setting working on windows7????
can anyone help me?
why do i get a blank page after logging in into phpmyadmin?
how do i fix this?
thanks for the help!
The solution to this blank page problem is fairly easy. Simply modify this line in the phpmyadmin/config.inc.php
$cfg['Servers'][$i]['host'] = ‘localhost’;
to this:
$cfg['Servers'][$i]['host'] = ‘127.0.0.1′;
Anybody can help me, or give me the working php and apache conf files. please
A potential solution is to find the ntwdblib.dll library (downloadable from msdn) and to copy it in C:WindowsSystem32 folder. For some reasons this library is missing for PHP to work properly
Look at the following address: http://www.dlldll.org/dll-files/ntwdblib-dll.html
thanks for your help, finally i was able to fix this issue, I downloaded php-5.3.2-Win32-VC6-x86 and things got fixed.
Dear Michael,
I have been trying since three days to make this happen in my Windows 7 Ultimate edition. But its not working. When I comment this #PHP5
LoadModule php5_module "C:/server/php/php5apache2_2.dll"
PHPIniDir "C:/server/php"
It works, that means the problem is in this part
I installed apache 2.2.11 win 32 x86 open ssl-0.9.8
Php 5.3.0
Could you please help me, once im able to fix this I need to upgrade my desktop which has win xp pro and running with apache 2.0.8 and php 5.
Please could you help me, I really need this on my Windows 7. Or if you can send me the working config file for php and appache i will just replace it. It will be a great help for me.
I had this pronlem when i installed PHP 5.3, after reading several post in the net, my issue was solved, I used this version of php php-5.3.2-Win32-VC6-x86
getkhizer: WOWW…Excellent tutorial..Nice work…Bless you man
And to people WITH THE BLANK MYPHPADMIN PAGE:
you need to rename and populate the config file in the pma dir
- rename it from config.sample.inc.php to config.inc.php
- fill in some value between the two single quotes on the line $cfg['blowfish_secret'] = '';
for example: $cfg['blowfish_secret'] = 'couldbeanythingtypedhere123';
- alter the value $cfg['Servers'][$i]['host'] = 'localhost';
change it into: $cfg['Servers'][$i]['host'] = 'www.myserver.dev';
- optional: add the line
$cfg['Servers'][$i]['user'] = 'root';
and the line
$cfg['Servers'][$i]['password'] = 'root';
that last change allows you to bypass the login screen.
good luck
TO ALL THOSE WITH mysql and mysli NOT SHOWING UP:
re-quoting Jamie's comment here:
There is a problem with the following part in the php.ini edit section.
3.Edit 1
Find extension_dir = "./" and replace it with (Please note the slashes)
extension_dir = "C:/server/php/ext"
it doesnt mention removing the ; semi-colon. I was only getting MySqlnd and not the other two. I got rid of the semi-colon, rebooted my computer and then did my localhost and it worked.
worked for me.
brilliant manual – thanks!!
thank you for the post it work 100%
can you tell me How to set sql database conection in dreamweaver with this local config.
Hi, this stuff does work BUT there is one thing, It cant find my index.php file. If im typing localhost/index.php it just printing out the code in the webbwindow >.< U know how i can solve this? *hugs*
every thing is configured correctly…i also got the php admin page asking me to enter username and password…after entering these information and hitting the enter button i get a blank page with the address as(http://www.myserver.dev/pma/index.php?token=353e2...
i am using apache 2.2.14,php 5.1.3,mysql 5.5-m2 and my php admin 3.2.4 on a windows 7 ultimate(7600) x64 computer….is ther another other configuration needed to be done……thank you
i am using win 7 (7600) x64ulitmate..
I have installed apache 2.2.14,php 5.3.1, mysql 5.5-m2(essential)..every thing worked fine
as you said……But i want to change the port number of apache server to 800 coz i want
to use the port 80 for ISS…I followed the link and downloaded PHPMyadmin but when i run
this “http://localhost/pma/index.php” on mozilla firefox 3.5.5..i get the message as
“Deprecated: Function eregi() is deprecated in
C:\Serverwww\myserver.dev\public_html\pma\libraries\select_lang.lib.php on line
146″…
plz help….
146\www\myserver.dev\public_html\pma\libraries\select_lang.lib.php on line 146
No work, I receive the following error on a alert:
the requested operation has failed.
help me please…
Hallo from Germany
With that code in the httpd.conf I become an Error when I try to start the Server:
LoadModule php5_module modules/php/php5apache2_2.dll
PHPIniDir modules/php
But also with yout type of code, I just got this error:
"The requestet Operation has failed."
When I put tweo # to the codes it works.
Can anyone Help me?
Even i have the same error, im using windows 7 ultimate editions, did
you solve your problem.
hi,
the error i got is:
Syntax error in line 118
LoadModule php5_module "C:/server/php/php5apache2_2.dll"
where can i find php5apache2_2.dll
please help
thx for this tutorial.. great..
part 3
for($i = 0; $i < mysqli_num_rows($result); $i++)
{
echo "<tr>";
$row_array = mysqli_fetch_row($result);
for($j = 0;$j < mysqli_num_fields($result);$j++)
{
echo "<td>".$row_array[$j]."</td>n";
}
}
echo "</table>";
}
?>
</body></html>
I am using:
Linksys WRT54G2 v1 router
Gateway nv58 laptop
windows 7
php 5.3.1 win32 vc6 x86
mysql essential 5.1.41 win32
Apache 2.2
I did all of the above (except phpadmin and windows recog) and the phpinfo worked (it showed Mysql, MySqli, and MySqlnd).
I did port forwarding on my router for apache and mysql also. any other suggsetions or Ideas would be nice.
you can try the program at http://www.jcws.ca/mysql_up.php
both my apache, mysql and php are installed on the same system.
part 2
the code I am running is as follows:
<?php
/* Program: mysql_up.php
* Desc: Connects to MySQL Server and
* outputs settings.
*/
echo "<html>
<head><title>Test MySQL</title></head>
<body>";
$host="localhost";
$user="myusername";
$password="mypassword";
$cxn = mysqli_connect($host,$user,$password);
$sql="SHOW STATUS";
$result = mysqli_query($cxn,$sql);
if($result == false)
{
echo "<h4>Error: ".mysqli_error($cxn)."</h4>";
}
else
{
/* Table that displays the results */
echo "<table border='1'>
<tr><th>Variable_name</th>
<th>Value</th></tr>";
part 1 (had to split comment up into three)
anytime I run a request for info from mysql i get this message after 60 seconds
Warning: mysqli_connect() [function.mysqli-connect]: [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306) in (I removed path)mysql_up.php on line 13
Warning: mysqli_connect() [function.mysqli-connect]: (HY000/2002): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in (I removed path)mysql_up.php on line 13
Fatal error: Maximum execution time of 60 seconds exceeded in mysql_up.php on line 13
There is a problem with the following part in the php.ini edit section.
3.Edit 1
Find extension_dir = "./" and replace it with (Please note the slashes)
extension_dir = "C:/server/php/ext"
it doesnt mention removing the ; semi-colon. I was only getting MySqlnd and not the other two. I got rid of the semi-colon, rebooted my computer and then did my localhost and it worked.
brilliant! Solved the problem for me.
I wish that would work for me, but I still don't get MySQL or MySQLi. I followed the tutorial carefully several times. I've tried so many things, but nothing works. Still no connection to MySQL. Please help!
Thanks for the article! I was having problems to install the 5.3 php version.
You saved my life!
About god damn time.
Im doin software development and this is EXACTLY what i needed!!
☺
Tutorial updated. Congratulations on your initiative!
Which has been updated???
thanks michael , i m newbee just finished installing step by step as directed by you but after installing mysql apache server failed to start
1. when i click http://localhost it give me page of it works i have to manually enter " /index.php" to get me the
php page
2. on starting apache it gives me error
" httpd.exe: could not reliably determine the server's fully qualified domain name , using 124.125.31.171 for Server Name ( OS 10048) Only one usage of each socket address <protocol/network address/port > is normally permitted. : make_sock:could not bind to address 0.0.0.0:80 no listning sockets available, shutting down unable to open logs …..
Note the errors or messages above, and press the <esc> key to exit.
3. php myadmin gives error
The additional features for working with linked tables have been deactivated. To find out ….
The configuration file now needs a secret passphrase (blowfish_secret).
Please help !
I'm having a bad time trying to get my windows web server operational. I tried a BitNami stack, which installed beautifully but wouldn't take Coldfusion, so I had to uninstall and look elsewhere. I tried your tutorial and got on quite well initially. Everything seemed to go fine with Apache and PHP, though I didn't actually test to make sure php was working once I'd installed it – definitely fine after apache installed, though. The problems I've had are with the MySQL install. After several attempts at clearing MySQL off the hard disk as completely as I could without editing the registry (which is perhaps the problem, but would generally be my absolute last resort!), I've had to remove the whole lot, apache, php & mysql and try XAMPP. However, I may still hit problems when I come to install Coldfusion and would quite like to 'cure' the problem I had with the MySQL installation and would then go back to this method at a later stage.
Anyway, sorry for the ramble. The problem was that I couldn't get anything up in the browser after the 'successful' install of MySQL. It was version 5.1.41 rather than 5.1.36 as I couldn't get that version. It just gave me a 403 Forbidden page. If you can think of any reason why that would happen and what I could do about it, that would be superb. I'm used to using my Mac server (have a MAMP PRO setup), which works great and has accepted Coldfusion 9, but my Uni assessment requires me to connect to an Access database and there isn't a mac version of Access. As I live a significant distance from Uni, I need to set up a testing server at home so I can work on my assessment and then take the files in to Uni with me when I go in twice a week. Unfortunately, though I believe it should be part of it, the course doesn't cover setting up a testing server as IT set it up for the students, otherwise I could perhaps get help from Uni.
Hope you can help,
Liz
I had a lot of problems running Apache with multiple versions of PHP.
The problems was because of the PATH variable.
I created a small program called Pepper!, it switches the PATH variable on runtime.
So you can install multiple versions of PHP and use the CLI.
It's still very simple, i'm working on it!. I you want, you can give it a try:
Pepper!: http://pepper.nutshell.nl/
I've installed these on my Vista machine:
apache_2.2.14-win32-x86-no_ssl.msi
mysql-essential-5.1.41-win32.msi
php-5.3.1-Win32-VC6-x86.zip
I followed all of your instructions above up until Step 5 (7. Test MySQL along with Apache+PHP) which I got stuck. I swear I have installed everything successfully. But when I go to http://localhost I have not come across any mysql & mysqli heading. PLEASE HELP???
very well done, i've tried dozens of times and yours was the first to work
Thank you!*
It's an excelent tutorial!*
i use apache_2.2.14-win32-x86-no_ssl & php 5.3
when i restart apache
httpd.exe: Syntax error on line 128 of C:/server/apache/conf/httpd.conf: Cannot load C:/server/php/php5apache2_2.dll into server: This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem.
can you help me with this problem?
I have the same problem. The syntax seems to be fine:
#PHP5
LoadModule php5_module "C:/serveris/php/php5apache2_2.dll"
PHPIniDir "C:/serveris/php"
I named the installation directory ''serveris'' instead of ''server'' (the same thing on my native language), everything else was done exactly as in this tutorial.
for PhpMyAdmin 3
Your link http://www.myserver.dev/pma/index.php should this be
http://www/myserver.dev/public_html/pma ?
Even then cannot find index.php
Thank you Michael. You're the boss.
Please try using the latest version of PHPMyAdmin.
Important note:
Use the "ZIP" version of PHP and not the "EXE" one . The "ZIP" file includes php5apache2_2.dll where the "EXE" do not.
In step 2.2 , the php.ini can be found as php.ini.recommended (just deleted the .recommended)
Hi, i need a lot of help, i followed the tutorial twice and apache can't show my php files, i restarted my pc when it was needed, and apache too, but i can't figure out whats going on.
By the way im using apache2.2, php 5.3.0 and Windows XP, for now i don't need MySQL
any particular problem you are facing ??
I am assuming you must have not added the type .php .phps in Apache httpd.conf file.
Please verify step 3.3
thanks a lot. mine was Vista and i was constantly having problem trying php .msi installer. finally i got to set php up using your guided steps.
your welcome
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…
Muy bien. Gracias.
This is a great tuturial! Thank you for sharing it.
Also found I need to do Step 7 to get Step 6 to work
Thanks
I initially had a problem but assume there is a typo editing the conf file:
Edit 5
Search for
#Include conf/extra/httpd-vhosts.conf
Replace with
(nothing here in script assume it should be 'Include conf/extra/httpd-vhosts.conf')
… then it works
my bad for the typo, the article has been updated
Thanks Clarke
I followed every step to the capital T but once i get to the mysql piece, all hell breaks loose. Ok, so i started to install mysql and everything is fine until it gets to the dialog box where it asks to set the security options. It is asking me for a current root password. Why? I don't have a current…Should i just leave this blank? I don't understand. The screen you have does not have that option so for some reason I am getting "current root password" please help. i am going crazy here….
It seems that when I double click on the php file I get the code in the browser but when I use http://localhost, it works fine.
Is this how it is supposed to work?
Fantastic Tutorial.
I am, however having one problem (so far). When I open up index.php i get the following inside of Internet Explorer:
<?php
//index.php
phpinfo();
?>
I have checked, double checked, and triple checked all paths. Seems fine.
The only change that I made was to change the path to .server instead of C:server but I changed all of the paths to reflect this.
Any help would be greatly appreciated.
AP
Hey thanks for a super tutorial – I have installed and used Apache, php, MySQL and phpMyAdmin on a WinXP box in the past but was struggling to get everything working correctly on my Vista PC. With the help of this fine tutorial I now have everything working again
I did notice a few issues though during the setup like missing .dll files (which I have now sorted out thanks to the other users comments found here) – one thing though, never quite got httpd-vhosts.conf to actually work… just said I was not Authorized to view the page… I am guessing that this may have something to do with DocumentRoot still being set to "C:/Webserver/Apache2.2/htdocs" within my httpd.conf even though httpd-vhosts.conf points elsewhere?
also might be an idea to tell people to set 'short_open_tag' to On within php.ini to allow older (non complient) php scripts to work correctly…
Excellent…exactly what i was looking for and works! thx
thank you so much! i wish i could have come across this quicker, i wasted 6 hours trying
to figure this out before i found your post. thanks again
Thank you for an excellent article Vaishnavi! It was a great help.
Great tutorial. Gives (a newbie like me) some idea as to how the components tie together.
Only problem i hit was the very last step.
I did find the same error in the script as did Paul just before me. Still very very helpful for me.
When I installed the PHPMyAdmin and then tried to get Windows to recognize http://www.myserver.dev using Notepad to edit Hosts under System32/drivers/etc I used save as with type all files but I keep getting Cannot create the …. file
So, I made it to the last line, but this one (I think) is what keeps my root root logon to pma from working.
Any ideas? Thanks in advance!
Any ideas?
OK, just a security issue. temporarily changed the hosts file properties to allow update.
what exactly did you do? because i am getting the same error…?
loool i already found out what the problem was… there´s a mistake made in the tutorial at apache Edit 5
It should be replaced with ´Include conf/extra/httpd-vhosts.conf´ but not completely removed! Perhaps someone can fix that? would have spared me a lot of time -.-''
Search for
#Include conf/extra/httpd-vhosts.conf
Replace with
….
# Now navigate to C:serverApacheconfextra
but tnx for the tutorial!!
Hi Paul. I just found the same error in the script. Still very helpful for me. Did you install the PHPMyAdmin and try to get Windows to recognize http://www.myserver.dev???? I tried with Notepad to edit Hosts under System32/drivers/etc using save as type all files but I keep getting Cannot create the …. file
So, I made it to the last line, but this one (I think) is what keeps my root root logon to pma from working.
Any ideas?
Hmm i just found out that if i delete the index.html in htdocs and place the index.php there it works… and if i delete index.php as well it gives index/
That means that it doesn't connect through to the www/../../ map ;s anyone knows how to solve this?
I followed the tutorial and everything seems to work fine except for the moment that I go to http://localhost/
It keeps saying 'it works!' anyone got a clue??
Thanks a lot. Helped me out.
I have spent days trying to configure apache and php to recognise mysql on windows vista,all was too much headache without success.And lets say i was lucky today to burst into this tutorial and following the steps just took me couple of hours to do all at once.THANKS Man ALOT!!!!
Hi! I am having trouble with mysql. i keep getting the following:
#1045 – Access denied for user ‘root’@'localhost’ (using password: yes)
can you help me out?
hey michael! thanks for the detailed instructions. quick question, when editting the httpd.conf file, what do we replace with in step 5?? looking forward to hearing from you!
continuing on my last post here after some more work.
Had missed the last step with the myserver.dev option.. after configuring the host file in
windows32 I now get the “It works!” browsing to it…
Opening the phpinfo script with phpdeveloper gives me the following information
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.45
Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
hi i have installed using the instructions on here for on my windows xp machine but when i retarted the apache server i got php startup unable to load dynamic libary "C:php5php_gd2.dll" Uhis happens for anything to do with php i followed the instructions and pointed it to C:serverphp but its still lokking for C:php any ideas
iam unable to login after installing phpmyadmin.giving error not allowed for root@localhost(using password) yes
hey mic, how are you? i was trting to change my MySQL…. i take MySQL 5.1.36 instead of MySQL-essential 5.1.36-win32.msi,… it is OK? i used different version… please let me know mic..thank you….
Hey,
it should not be of any problem, it should work fine.
Legend. Thank you for this tut
Please i need the video is the best way to learn to instalation of server thank you.
you can check out the screencast
http://webdevcodex.com/screencast-installing-apac...
After taking a breather I just wanted to let you know that I was able to resolve my own problem in the index.php file YAY! Thanks for the great tutorial it was awsome! I am really looking forward to learning more.
Hello Bryan,
The code is
<?php
phpinfo();
?>
and you had posted it is
< ?php
phpinfo();
?>
(there was a space between < and ?)
Sorry for the delay in posting, glad you got it working
I posted this on Visionmasterdesigns.com also but I read that this site is the new focus so I'll repost my question here in hopes of help.
Hi,
I have almost made it to the end of my journey in this fun set up process, but like most I just can’t figure out where I have gone wrong in this last part. Once I get to:
After it has restarted (green play icon will be displayed), point your favourite web browser to http://www.myserver.dev.
I tried that and the following appears in my browser
1.< ?php//index.php 2.phpinfo(); 3.?>
Also to add onto my last request. The mysql did load the final step just fine. The mysql command line client shows it is running. I don’t know if this helps determine anything….
Can you please help me?
Thanks in advance!
Bryan-
Hello Bryan,
The code is
<?php
phpinfo();
?>
(there is no space betweet < and ?)
also please verify that the file name is index.php and not index.php.txt.
Regards
Dynamic error to compile mysql, mysqli, and mssql dll files do not match ? what is the deal i have done these steps in this guide over and over way to many times. also php-5.2.9-2-Win32 does not even have php_mssql.dll file in its folder. This is when i restart my apache server. Still runs tho even with that errror…
I have the apache part working find http://matrix.info
Dynamic error to compile mysql, mysqli, and mssql dll files do not match ? what is the deal i have done these steps in this guide over and over way to many times. also php-5.2.9-2-Win32 does not even have php_mssql.dll file in its folder.
The server keeps references me back to C:/php5/ why is that ?
All i could get was the apache server to install. PHP is not working with it…. I check my firewall to bypass the ports needed to do this..
Device Allowed Applications Application Type Protocol Port Number(s) Public IP
matrix Web Server – TCP 80
FTP Server FTP (file transfer protocol) server TCP 21
DNS Server – TCP 53
UDP 53
HTTPS Server – TCP 443
TCP/IP Networking – TCP 3306
Im haven problem with mine as well.
There is no php_mssql.dll in my folder..
Dynamic error to compile mysql, mysqli, and mssql dll files do not match ? what is the deal i have done these steps in this guide over and over way to many times. also php-5.2.9-2-Win32 does not even have php_mssql.dll file in its folder. This is when i restart my apache server. Still runs tho even with that errror… The apache server still starts up and restarts but it is given those messages..
http://matrix.info
You don`t require php_mssql.dll, so don`t worry about that
Hey I get up to just before restarting the apache webserver, and it doesn't restart, I backed tracked and took out the changes until it restarted, then went forward. it was this code…
#PHP5
LoadModule php5_module "C:/server/php/php5apache2_2.dll"
PHPIniDir "C:/server/php"
I have yet to get everything working together with the instructions here. Can anyone show me where I went wrong?
thank you,
Michael Cote'
LoadModule php5_module "C:/server/php/php5apache2_2.dll"
PHPIniDir "C:/server/php"
This code seems perfectly correct. Please check whether the path to the PHP folder's are proper. Also make sure Apache can access php5apache2_2.dll file.
Also check the logs/error.log for more info. Posting the error from the log may help in deciphering the problem
hello mic,
i have a problem,my apache have trouble finding mySQL extensions.
it say’s ” cannot load mysql extension. please check Php configuration-
documents”. when i point the mywebserver into http://www.myserver.dev/or in
index.php, it is working but the mysql and mysqli is not found there.
please help…
Please make sure mysql is running John
Double check by
Start->Run (type CMD)
then
>mysql -u root -p (press enter)
(it will prompt password, enter root)
Once inside mysql root, type
>/s (press enter)
and check whether MySQL service is on or not !
Hi mic,
I am able to connect to mysql now using phpMyadmin. Thanks a lot.
mic,
how i can connect the mysql to php? i will save to
http://www.myserver.dev/public_html after the php script.
hello mic,
Thank you very much for the tutorials. i runned everything. but i
have a little problem with my PHPmyAdmin. everytime i open in your
instruction, it say’s
“cannot load mysql extension Please check your PHP configuration-
Documents”.
how i can connect the PHPmyAdmin to mysql?
i cannot open the PHPmyAdmin in web server
“www.myserver.dev/pma/index.php”….
i follow all your instruction… please help me…
Great job. This was a fantastic tutorial. Installed perfectly under my XP Pro VMware
image. Also might want to recommend Notepad++. Great little program.
Thanks a lot Jeff
First of all i would like to thank Vaishnavi for this wonderful document. I
did all the steps how it is mentioned here. But i got strucked in Step “Test
MySQL along with Apache+PHP” here when i point by browser to
http://localhost i am getting
” — This output in my browser. So i have not moved further before i
resolve this. I am using Windows XP Professional O/S.
So please if you guide me from here it will be very helpful.
Thanks
Khan
Hello Khan,
I believe we would require more details as to decipher what the problem could be. This tutorial does work with XP as well so its not an issue.
if you can attach a screenshot of what the error is or describe more in detail as to what the error is, it may really be helpful
Regards
Hello Mike,
As i am unable to attach the screen shot. So i will explain you exactly
my problem. I have done all the steps as its mentioned in this above
document. Till the installation of MySQL 5.0 the steps are going fine
after installation of MySQL we need to test Mysql along with
Apache+PHP. To do this we need to restart Apache service and point
our web browser to http://localhost. Here i suppose to get PHP page
which is displayed above but instead i am getting contents if index.php
file. like
I hope its clear to you now.
Thanks
Hey Khan,
Please double check whether you have saved the file as
index.phpinstead ofindex.php.txt.Check whether the following are the contents of
index.phpHi,
Thanks a lot…am aspiring to learn php in web designing..this surely helped me a
lot….trying to setup a website in my workplace and I sincerely appreciate your help!!!
hello pskavita,
We are very glad that this article really helped you out.
Do come back for more web development tips and techniques
hey mic,
i forget to tell you that i’m using notebook during installation….it’s OK?
No issues John, it is afterall a PC
Great Tut… Seam WorX :@)
Ther’s only a little TypoBug:
On point 3, it seam to be written: “php5 module”
Instead of what Should NeeD: “php5_module”.
Thanks for pointing out the typo
Worked a treat.
Finally got my own dev copy of http://www.qwikioffice.com/ web desktop up and running.
thanks for the guide.
Sure thing
hello mic,
where can i find the instance of mysql in “REGEDIT”. what are the
instances of mysql? please give me a specific location from REGEDIT. i
finished unsinstall the mysql and especially the mysql.ini….if i found the
instances of mysql in REGEDIT, after that i install again the MySQL?
please help me mic….thank you…
hey John,
There seems to be a lot of trouble regarding the installation of mysql in your PC. goto Start->run, type regedit
use the find tool, to find “mysql”, as it finds instances of mysql, delete em.
Also do a full system search on “mysql” and delete whatever comes up. Hope it helps
mic
i used your tutorial site :
http://visionmasterdesigns.com/tutorial-installing-apache-php-5-mysql-5-
phpmyadmin-windows-vista-xp/6/
i follow the structured, i got it my apache and PHP are workin..only mysql
have a problem…..
#1045 – Access denied for user ‘root’@’localhost’ (using password: yes)
yes john, this tends to happen, when you already have mysql installed or some files of mysql are remaining.
First uninstall mysql then its time to edit the registry
open up “regedit” from start->run
and search for every instance of mysql and delete the keys (its a very dangerous procedure, as you might risk damaging the registry, so backup before you do anything)
hello mic,
i got it already, i follow ur tutorials. about my PHP, i used your version
and i changed it like this:
;extension=php_bz2.dll
;extension=php_curl.dll
;extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_exif.dll
;extension=php_fdf.dll
extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_gmp.dll
;extension=php_ifx.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
extension=php_mbstring.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
;extension=php_msql.dll
;extension=php_mssql.dll
extension=php_mysql.dll
extension=php_mysqli.dll
;extension=php_oci8.dll
;extension=php_openssl.dll
;extension=php_pdo.dll
;extension=php_pdo_firebird.dll
;extension=php_pdo_mssql.dll
;extension=php_pdo_mysql.dll
;extension=php_pdo_oci.dll
;extension=php_pdo_oci8.dll
;extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
;extension=php_pdo_sqlite.dll
;extension=php_pgsql.dll
;extension=php_pspell.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
;extension=php_soap.dll
;extension=php_sockets.dll
;extension=php_sqlite.dll
;extension=php_sybase_ct.dll
;extension=php_tidy.dll
;extension=php_xmlrpc.dll
;extension=php_xsl.dll
;extension=php_zip.dll
but i have a problem installing my MySQL version 5.1.34-win32.msi, i
installed and uninstalled several time, thesame problem with the last
setting for “apply security setting”.
The error occured : ” The security setting could not be applied.
Error number 1045.
Access denied for user ‘root@localhost’(using password: yes)”.
My apache and PHP are working…problem with mysql..
everytime i install again the mysql, same error…
please help mic…thank you…
hey mic,
here is some of my php.ini file. before i configured the php.ini file, there
is no comment in related line. just take a look, i copy and paste the mysql
extension :
[PHP_BZ2]
extension=php_bz2.dll
[PHP_CURL]
extension=php_curl.dll
[PHP_GD2]
extension=php_gd2.dll
[PHP_GETTEXT]
extension=php_gettext.dll
[PHP_GMP]
extension=php_gmp.dll
[PHP_IMAP]
extension=php_imap.dll
[PHP_MBSTRING]
extension=php_mbstring.dll
[PHP_MYSQL]
extension=php_mysql.dll
[PHP_MYSQLI]
extension=php_mysqli.dll
[PHP_OPENSSL]
extension=php_openssl.dll
[PHP_PDO_MYSQL]
extension=php_pdo_mysql.dll
[PHP_PDO_ODBC]
extension=php_pdo_odbc.dll
[PHP_PDO_SQLITE]
extension=php_pdo_sqlite.dll
[PHP_PGSQL]
extension=php_pgsql.dll
[PHP_SOAP]
extension=php_soap.dll
[PHP_SOCKETS]
extension=php_sockets.dll
[PHP_SQLITE3]
extension=php_sqlite3.dll
[PHP_TIDY]
extension=php_tidy.dll
[PHP_XMLRPC]
extension=php_xmlrpc.dll
[PHP_EXIF]
extension=php_exif.dll
when i installed the mysql, i never put the “apply security setting”. i never
cheked the Modify security setting box. but the mysql is working.
by the way mic, what msqlnd? in my phpinfo() web browser,.. i never
seen the mysql and mysqli..only mysqlnd. thank you mic…
I am kinda clueless John,
have you followed the tutorial exactly as it is ? mysqlnd is a native driver of mysql for PHP
Hi Michael,
I'm having similar MySQL problem as John above. Have you figured out how to solve it? I followed every step you described as it is (apart from i set the mysql to C:serverMySQL but tht shouldnt be a problem rite?). Please guide me what to do next?
hey mic,
i got a problem with my PhpMyAdmin. The web browser loaded :
phpMyAdmin – error “cannot load mysql extension, Please check your
PHP configuration – Documentation.
I think there is a problem installing of mysql. because i checked the my
web browser in index.php, There is no MySQL and MySQLi. it just only
the MySQLnd.
But MySQL work properly but no password because i didn’t apply the
security setting in my MySQL.
please help me mic…Thank you…
hey John,
I think your mysql hasn`t been installed and configured properly.
Please uninstall mysql completely, and remove any instances of
mysql.iniin your drives. Then reboot your system and try installing again.The MySQL server Instance Config Wizard must be successfully completed for mysql to work properly.
If you are sure that mysql has been installed properly, then check
php.iniand see whether the required mysql extensions are enabled.I had the same problem, but then noticed that when I edited my php.ini file I forgot to removed the ; before the extension_dir section. It doesnt mention to in the instructions, but I tried and it worked.
mic,
what if i don’t take a security setting to mysql, it still be OK?
what is the risk?
Hi mic,
i installed the mysql 5.1.36-win32. it still thesame problem. there is a
error about security setting.
“The security setting could not be applied.
Error number 1045.
Access denied for user ‘root’@'localhost’(using password:yes)
please help…thank you
Excelente tutorial, segui os passos e foi muito fácil. Obrigado!!
Excelent tutorial, run step by step and its very easy. Thank you.
Thanks a lot Cicero
hello michael,
i download already the PhpMyAdmin 3.2.0.1-all-languages.zip.
how i can extract the file? becuase it is a zip file and open only in
notepad. but the code is broken when i open. Please show me..
thank you…
Hey,
try using WinRAR or any other program. It is not very hard to extract it and don`t worry, the code isn`t broken, if it is, try downloading from another mirror
Thank you michaael,
i would like to ask if it’s Ok to use apache 2.2.11-win 32-x86-openssl-
0.9.8i ? because i installed this kind of apache. It’s OK also to use without
PhpMyAdmin?
yes, there won`t be any issues using apache with openssl
BTW PhpmyAdmin is completely optional.
Many thanx! I’ll translate it for russian users!
Michael,
i’m finished downloading PHP 5.3 VC9 and apache 2.2.11, it was successfully installed and configured. Now, i download MySQL 5.2.3-essential and i encountered error in the last setting for “apply security setting” configuration. I never install MySQL previously, this is for the time to connect with my PHP 5.3. My PHP and apache are working properly but MySQL have a problem…
Where do i go and what should i do? remove the MySQL ?
Hey John,
Please download the MySQL 5.1.x versions
Since you have already tried installing MySQL 5.2.3, i would suggest you to remove it completely. renove
mysql.inian then install mysql 5.1.xHello michael,
i have a problem with my MySQL configuration. im using MySQL 5.2.3 version and PHP 5.3 VC9 version. It’s that OK? The last setting of my configuration in MySQL is to execute. when i execute the configuration, the last setting ” Apply security settings” have an error.
The error occured : ” The security setting could not be applied.
Error number 1045.
Access denied for user ‘root@localhost’(using password: yes)”
Hello John,
first off, you need to download PHP 5.3 VC6 (if you want to install it along with Apache) else PHP 5.3 VC9 (if you want to install it with IIS)
Secondly, I am assuming you already had a previous installation of MySQL ?
You need to completely remove the previous installations so as to proceed with the new. Try searching your entire system for MySQL and delete all dependencies (especially mysql.ini)
Regards
Hello michael,
i was configuring httpd.conf. In edit number 3, where do i add the line :
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
after the line search of
“AddType application/x-gzip .gz .tgz” line or
“#AddType application/x-gzip .tgz” ?
I’m hoping for your answer and reply. i look forward to hear from you..
Thank you very much…
hello John,
You can add it anywhere around those searched lines.
I would suggest you to add it immediately after
AddType application/x-gzip .gz .tgzRegards
it worked, many thanks, your the best
yes I got the word “Testing..” only.. so my PHP should be working fine!
I tried openning the index.php on explorer and firefox, and both show the content of the code…
Hey Mark,
Your php is working fine, there was a typo in the tutorial and I am extremely sorry for not noticing it earlier.
This is the code that should be in
index.php, the typo was that there was a space in the php opening tag like this<?php.This is the correct code
Changes have been made to the tutorial as well.
Once again, I am extremely sorry for the trouble.
I got the word testing when creating the test file, I did create the html file and still no luck.
you got the output as the word “Testing…” ??
if you did then php is running successfully
or did the entire code show up when you opened
test.phpMike, any chance that you read my files?
hey Mark,
yes i am going through your files, but I haven`t found any problem.
It seems perfect.
please create another file called
test.phpthen try opening, http://localhost/test.php
please be sure of saving it as
test.phpand nottest.php.txtIf it still ain`t workin, just try creating a normal html file and open it via your browser.
Michael,
Thanks for your response. I seem to be now having problem installing MySQL … I get to the MySQL Server Instance Configuration. Click on Execute and it fails on 'Start Service' with the eror message “Cannot create windows service for MySQL. Error: 0″. I have tried removing this instance, unistall and re-install a couple of times. Help!!!!
Have you had any previous installations of mysql ??
I had MySQL on my system before but I had my laptop restored to its factory setting a few months back.
hey
restoring to factory settings must have formatted your harddrive
was mysql installed on the same drive ??
either ways, I would suggest you to reinstall it in an another drive.
also please delete any remains of mysql in your driive.
Michael,
Never mind … did a little troubleshooting and finally figured out what I did wrong. Once again, thanks for the awesome tutorial.
Sure thing Moni,
lemme know if you need anything
Moni,
I have the same problem as you were having (the pid error, Unclean shutdown…). Can you
kindly elaborate about what issues you have tackled and solved to Apache running with PHP.
Hi Michael,
Thanks so much for this tutorial. I am however having a problem. I installed Apache 2.2 and PHP with no problem. However, once I edit the httpd.conf and httpd-vhosts.conf files and I attempt to restart Apache as directed in the tutrial, I keep getting an error Error 1067: The process terminated unexperctedly.
In error.log, I have the following:
Starting the Apache2.2 service
The Apache2.2 service is running.
] Apache/2.2.11 (Win32) configured — resuming normal operations
[Fri Jul 17 06:27:54 2009] [notice] Server built: Dec 10 2008 00:10:06
[Fri Jul 17 06:27:54 2009] [notice] Parent: Created child process 3872
[Fri Jul 17 06:27:55 2009] [notice] Child 3872: Child process is running
[Fri Jul 17 06:27:55 2009] [notice] Child 3872: Acquired the start mutex.
[Fri Jul 17 06:27:55 2009] [notice] Child 3872: Starting 64 worker threads.
[Fri Jul 17 06:27:55 2009] [notice] Child 3872: Starting thread to listen on port 80.
[Fri Jul 17 06:34:13 2009] [error] [client 127.0.0.1] File does not exist: C:/server/apache/htdocs/favicon.ico
[Fri Jul 17 06:34:16 2009] [error] [client 127.0.0.1] File does not exist: C:/server/apache/htdocs/favicon.ico
[Fri Jul 17 06:39:30 2009] [notice] Parent: Received shutdown signal — Shutting down the server.
[Fri Jul 17 06:39:30 2009] [notice] Child 3872: Exit event signaled. Child process is ending.
[Fri Jul 17 06:39:31 2009] [notice] Child 3872: Released the start mutex
[Fri Jul 17 06:39:32 2009] [notice] Child 3872: All worker threads have exited.
[Fri Jul 17 06:39:32 2009] [notice] Child 3872: Child process is exiting
[Fri Jul 17 06:39:32 2009] [notice] Parent: Child process exited successfully.
[Fri Jul 17 06:40:51 2009] [warn] pid file C:/server/apache/logs/httpd.pid overwritten — Unclean shutdown of previous Apache run?
Can you please help me out? Thanks.
Hi Moni pls let me know what did you do. I got the same error.
Hey Michael, I sent you the files to the email you provided, hope you have the time to check them out.
Thanks,
Great post for starters man. But I found out that in the php 5.3.0, if I enabled ;extension=php_mysqli.dll, the info does not show up. If anyone else has a problem they can also check this great source
http://drupal.org/node/146679#comment-235582
Thanks for the help btw.
Hey Prashant,
thanks for your comment, actually, sometimes it doesn`t show up immediately.
You need to restart your computer once after editing PHP.ini and httpd.conf for the changes to come into effect
Regards
Yes exactly its showing this code, I checked the Apache Service Monitor and it does display the Apache/PHP service exactly as you mentioned and it states it is working fine, what next?
Many thanks.
Hello Mark
Please check whether you have performed Step -3 (Edit 3 and 4) in particular properly.
Those lines tell apache to execute .php files as PHP files.
If still you are getting the error, please send me a copy of your
php.iniandhttpd.confto contact@webdevcodex.com<code> </code>
I see the content of the index.php file. i made sure it is not saved as a .txt file and it is saved as .php file, yet its not working!
Thanks.
you mean, you are able to see the following code when you visit http://localhost/ ??
Please verify that PHP and Apache are working, check the Apache icon in the taskbar to see whether the Apache Service Moniter displays Apache/2.2.11 (win 32) PHP/5.3.0
Hello Michael,
Thanks for this great illustration on how to install the PHP, really your work is so neat and excellent.
Yet I have a problem and I hope you have the time to reply, I am trying to install php-5.3.0-Win32-VC6-x86, apache_2.2.11-win32-x86-no_ssl, mysql-essential-5.1.36-win32, phpMyAdmin-3.2.0.1-all-languages, on windows vista SP1, I have followed everything in this tutorial to the exact, but yet when I reach step 5 – 7 “7.Test MySQL along with Apache+PHP” and when I open the http://localhost, all I see is:
instead of the PHP page.
Can you please give me a hint of what I did wrong.
many thanks.
I wanna thank you so much for this site, this page realy realy help me so much whit the toturial:Installing Apache 2.2.11, PHP 5.3, MySQL 5.1.36 & PhpMyAdmin 3.2 in Windows 7/Vista/XP.
this site was the only that i found in tha web that explein the best way stape by stape how to install the web server . thank you very much, i wish you Success to this site, see you
Thanks a lot Lenmat for your kind comments.
Do Subscribe to our feeds to get more information about the latest technologies and How to’s !
oi! here’s the weird thing, now it’s there, but when i search for the other edits i made, they are not!
when editing httpd.conf Edit #4,
This could not be found:
Search for
DirectoryIndex index.html
Replace with
DirectoryIndex index.html index.php
Why is this not in my httpd.conf file???
Hey alejandro,
Edit#4 is present
just search for the text
DirectoryIndex(it should be around Line 238)make sure you also add
index.phpalong withindex.htmlin that line.Thank you for this page you wrote. I was struggling to get Apache, PHP, SQL onto my XP Home Edition computer because I am looking to get a job as a PHP programmer. I can now use PHP on my XP and I am extremely grateful for the effort you put into this page. Once again … thank you
David Cowdery
C:\webserver\Apache2.2\bin>httpd.exe -X
httpd.exe: Syntax error on line 79 of C:/webserver/Apache2.2/conf/httpd.conf: Ca
nnot load C:/webserver/php/php5apache2_2.dll into server: The specified module c
ould not be found.
THE DLL IS THERE
Hey,
1. Please check the path of
php5apache2_2.dllonce again.2. please note the path of PHPINIDir in Step5 Edit 2 of the tutorial. Also remember the quotes
""3. Restart the computer and then try editing
httpd.conffileIf you are still having an error, try extracting php into another directory, edit PHP first and then edit
httpd.confWell done, I was trying to install VC9