Apache, MySQL & PHP for Windows
Apache, MysQL and PHP for Windows could be a nice nice thing to have on your Windows workstation. You could try and experiment with all kinds of nice PHP and MySQL based applications right on your Windows desktop running Apache, instead of having to access a full-featured server.
Most people have Windows as their workstation and it can be sometimes difficult to switch to another operating system. So, you may have always wanted to run PHP applications on your Windows machine but wondered if it is too difficult to install or if the hassle will be worth it.
This article gives you the essential information to get started right away. Even if you are a seasoned PHP, MySQL and Apache guru, the checklist below will still be helpful in your installation process.
There are lots of 3rd party software that bundles Apache, MySQL & PHP in one package and installs them on our computer. We do not recommend this and suggest that you directly get Apache, MySQL & PHP from their official sites.
Apache
1. Get Apache 1.3.33 from here: http://httpd.apache.org/download.cgi.
2. Choose a mirror close to you and in the same page, look for the Win32 Binary (Self extracting) file: apache_1.3.33-win32-x86-no_src.exe.
3. Download the file and save it on your hard disk. Run the installer and the self- extracting wizard will guide you through the rest of the steps. Choose all the default settings and run Apache as a service.
4. Remember to put "localhost" when asked for a Server name/Domain name. Use "administrator@localhost" when asked for the administrative email account.
5. Now point your browser to: http://localhost and you should see an Apache Test Page.
6. You can change this page by creating an "index.html" page here "C:Program FilesApache GroupApachehtdocs".
7. You can manually start and stop the Apache server. In a Windows command prompt, type "net stop apache" or "net start apache".
MySQL
1. Get MySQL 4.1.7 from here: http://dev.mysql.com/downloads/mysql/4.1.html
2. Under the Windows downloads section, choose Windows Essentials (x86) and click on the Pick a Mirror link.
3. Download the file mysql-4.1.7-essential-win.msi and save it on your hard disk. Run the installer and the self-extracting wizard will guide you through the rest of the steps. Remember the root password when prompted for it in the installation process.
4. Once the installation is done, on your Windows toolbar, go to "Start->Programs- >MySQL->MySQL Server 4.1->MySQL Command Line Client".
5. Type the root password and you should be logged in to the MySQL shell.
6. Type "show databases;" to see the list of databases. Type "quit" when you are done.
PHP
1. Get PHP 4.3.10 from here: http://www.php.net/downloads.php
2. Under the Windows Binaries section, choose the file: PHP 4.3.10 zip package size 7,405Kb dated 15 Dec 2004.
3. Download the file and save it on your hard disk. Unzip the file and rename the extracted folder to "php". Now move this folder "php" and place it under "C: Program Files".
4. Move all the files under "C:Program Filesphpdlls" and "C:Program Filesphpsapi" to here: "C:Program Filesphp".
5. Copy the file php.ini-recommended to "C:WINDOWS" and rename it to php.ini
6. Edit your Apache "httpd.conf" configuration file located here: "C:Program FilesApache GroupApacheconf".
7. Add the following lines in httpd.conf:
LoadModule php4_module "C:/Program Files/php/php4apache.dll"
AddModule mod_php4.c
AddType application/x-httpd-php .php
8. Now stop your server by issuing the following command in Windows command prompt: "net stop apache". Then type "net start apache" to start your server. We are now going to test the PHP installation.
9. Go to "C:Program FilesApache GroupApachehtdocs" and create a file test.php
10. Edit test.php and add the following code:
11. Point your browser to http://localhost/test.php and you should see a lot of PHP configuration information.
Congratulations! You now have Apache, MySQL and PHP installed in your computer. Now you can install your favorite script right on your Windows workstation.
Sanjib Ahmad, Freelance Writer and Product Consultant for Business.Marc8.com - Business Best Sellers.
You are free to use this article in its entirety as long as you leave all links in place, do not modify the content, and include the resource box listed above.
Related Articles:
2009 'Future of Open Source' Annual Survey Results Announced at OSBC
96 Percent of Respondents Agree that Open Source will Thrive in the Turbulent Economy
MySQL AB & Carahsoft to Host a "Federal DBA Day" on January 24 for Oracle Database Users in the U.S. Government & Other Organizations
Free-of-Charge Technical Event in Washington, DC Follows Sold-Out Oracle Boot Camps in NYC & San Francisco
Sun Celebrates Third-Party MySQL Storage Engines: Oracle, Kickfire, PrimeBase Technologies and Infobright Join Sun
in Supporting the World's
Sun Microsystems, Inc. (NASDAQ:JAVA) today announced new and enhanced third-party support for the MySQL(TM) database's unique pluggable storage engine architecture. The MySQL Certified Storage Engine Program (www.mysql.com/engines) enables commercial and community database engine developers to certify that their software has been tested and is compatible with Sun's MySQL Database Server - helping to assure MySQL users that these certified engines have reached high-level standards of usability, performance and integration.
Professional Recruitment in Open Source Technologies
Open source development is gaining momentum day by day. The community of online open source developers is engaged in continuous development of new technologies as well as making existing technologies more robust. The development of new tools and development platforms are making programmers work easier. There are various segments of open source development like in the field of operating system, scripting languages, popular CMS, multimedia tools, web browsers and much much more.
CorraTech and Intalio Partner to Improve Business Processes Across Open Source Applications
Technology Partnership Will Allow Customers to Easily Define and Configure Business Processes Across Applications Through the OPENSUITE Platform
Sun Enhances MySQL Enterprise With New Query Analyzer Tool to Boost Database Application Performance : Paid Subscription Service Provides Enterprise
Sun Microsystems, Inc. (NASDAQ:JAVA) today announced a major new version of its MySQL Enterprise(TM) subscription service to help corporate users dramatically improve the speed and uptime of their MySQL(TM) database applications. MySQL Enterprise subscribers now have access to Sun's new MySQL Query Analyzer tool for monitoring query performance to accurately pinpoint and correct problem SQL code
credativ Announces OpenLogic Partnership and Broadens Reach for Open Source Support
credativ, a global open source service and support company, announced today a partnership with OpenLogic, Inc., a provider of enterprise open source software solutions. Together the companies are able to offer credativ's in-depth third level support to OpenLogic's customers throughout Europe and North America.
Open Source Development
Open source applications are available absolutely for free, which is like a boon for the open source developers programmers, as with these open source applications, they can take over the open source development in the customized way for different businesses as per the requirements.
KnowledgeTree Document Management Software Announces Adoption of GPL v3 Free and Open Source Software (FOSS) License
Adoption of OSI-approved GPL v3 License Strengthens Open Source Community Participation In Leading Open Source Document Management Project
Saugatuck Study: Open Source Changes Software, While Software Changes Open Source
Research and analysis indicate that software prevalence has changed the nature of "open source"
Sun Microsystems and Zmanda to Deliver Comprehensive Database Backup & Recovery Solutions for MySQL Enterprise Customers: Enterprise-Wide MySQL Dat
Sun Microsystems, Inc. (NASDAQ:JAVA) and Zmanda, the open source leader in backup and recovery software, today announced they are partnering to deliver a comprehensive, global data backup and recovery solution for MySQL Enterprise subscribers. A 30-day trial of Zmanda Recovery Manager Enterprise Edition -- the first open-source backup and recovery solution designed specifically for MySQL(TM) databases -- is available now at http://www.mysql.com/zrm. Starting April 1, MySQL Enterprise customers will be able to purchase ZRM for MySQL directly from Sun worldwide. Zmanda and Sun have also agreed to joint-selling and co-marketing activities in support of MySQL, the world's most popular open source database software. ...
UBmatrix to Open Source its Industry Leading XBRL Processing Engine
Intent on accelerating adoption of XBRL and making it a more fundamental piece of the enterprise IT fabric, UBmatrix to open its source code to developers on SourceForge.net
KnowledgeTree and CorraTech Partner to Provide Global Open Source Document Management Services
KnowledgeTree and CorraTech partner to promote popular open source document management software in North American and Western European markets.
Open Source Initiatives Need More Concerted Efforts
Major corporate houses choose open source partly due to the economic gains and mainly due to the control the open source system gives to their hands.
OW2 Consortium Launches Open Source Cloudware Initiative Lead by Strategic Members Bull, France Telecom and INRIA
In an unprecedented community effort, the OW2 Open Source Cloudware Initiative fosters open and interoperable cloud computing architecture through a bedrock of innovative, open source solutions for autonomic resource elasticity management.