I do not prefer the convenience of the “all-in-one” XAMPP package, which includes Apache, MySQL, PHP, and other utilities.
It can be challenging to tailor each component to specific needs or to optimize it for maximum performance.
When combining multiple parts into one package, isolating the problem from its source becomes more challenging.
Because of this, I decided to write this guide on the individual installation and configuration of Apache, MySQL, and PHP.
No other online resource will provide detailed instructions for installing each component independently as this one. Most other guides neglect to mention a crucial step in the configuration process for a successful installation.
I followed the instructions for this tutorial to install each component on a personal computer.
If you’re using Windows, follow these instructions.
If there is enough demand from you, my dear readers, I will compose another Ubuntu Linux tutorial.
Feel free to ask for clarification on these instructions if you have trouble setting it up. The information you need to contact me is on my website, linked in the “Further Reading” section below.
MySQL Installation Step 1: Download MySQL Community Server from mysql.com.
MySQL 5.1.42 is the most recent stable release during this writing.
MySQL-5.1.42-win32.msi is the name of the file I downloaded.
The following options should be used while running the MSI file:
* Usual Configuration
* Select “Configure the MySQL Server now” and “Register the MySQL Server now.”
Do the following: * Select “Detailed Configuration” * Select “Developer Machine” * Select “Multifunctional Database.”
The “InnoDB Tablespace Settings” section can be left at its default, and the “Decision Support (DSS)/OLAP” option can be enabled.
Ensure that both “Enable Strict Mode” and “Enable TCP/IP Networking” are selected. Don’t change the port number from 3306.
* Make sure “Standard Character Set” is selected and that “Install As Windows Service” and “Launch the MySQL Server automatically” is checked.
Make sure “Include Bin Directory in Windows PATH” is selected. Using this method, you can launch MySQL in command-line mode. It’s of great use.
* To prevent security vulnerabilities, change the root password and uncheck the “Enable root access from remote machines” and “Create An Anonymous Account” boxes.
* Select “Execute” to have MySQL set up locally.
Launch MySQL and make a new database just for WordPress. The database you create needs a proper name, which you should supply. I’ll use “WordPress” for the database and “wp-admin” for the administrator account. You can replace it with anything you like.
To use these commands, launch a terminal (MS-DOS or Cygwin) and type them in:
The command is: $ mysql -u root -p
Submit the Secret Question and Answer: ********
mysql> make WordPress database; Query OK, 1 row changed (0.03 seconds)
In a mysql prompt, I typed: grant all on WordPress.* to wp-admin @localhost with identifier ‘change’;
Invalid query; 0 rows modified in 0.03 seconds.
MySQL> reset privileges; Query OK, 0 records changed (0.02 seconds)
mysql> leave
Bye
To install Apache, get version 2.2 from apache.org and run it.
The name of the file I’ve downloaded is httpd-2.2.15-win32-x86-no_ssl.msi.
The following options should be used while running the MSI file:
Domain Name Server Name Administrator’s Email Address Your email @email.com * Network Domain localhost * Server Name localhost
The “for All Users” box must be checked.
A standard installation is as simple as clicking “Install” to begin configuring Apache on your computer.
Double-click the “Apache2.2” service you may find in Control Panel > Administrative Tools > Services once the installation is finished.
This is where you can terminate the service and switch to “Manual” startup.
How to Set Up Apache:
In C: Program FilesApache Software FoundationApache2.2conf, open httpd. Conf and edit it as shown below:
Take the following line out of the comments:
Modules/mod_rewrite.so LoadModule rewrite_module Include:
Use “C:/php/php5apache2_2.dll” in place of “LoadModule php5_module.”
Look for
Directory “C:/Program Files/Apache Software Foundation/Apache2.2/htdocs”>
Replace:
AllowOverride None With:
PermitOverride All
Follow these steps to add index.php to DirectoryIndex:
FileTypes: DirectoryIndex PHP, HTML
Find
Insert AddType application/x-httpd-php.php.phtml into the IfModule mime_module> section.
Put PHPIniDir “C:/php” at the end of httpd. Conf.
You must restart Apache for the new settings to take effect.
Third, get PHP by getting it from php.net (version 5.2.13).
The name of the file I just got is php-5.2.13-Win32.zip.
The downloaded file should be extracted to C: PHP.
Add libmysql.dll from C:php to C: WINDOWSsystem32.
Replace the file PHP. ini-recommended in the C:php directory with php.ini.
Launch Notepad and edit the C:phpphp.ini Uncomment file you just copied:
CAPTCHA requires the following: extension_dir = “ext” extension=php_gd2.dll.
extension=php_mysql.dll
extension=php_mysqli.dll
Add: date. Put “Australia/Melbourne” for the time zone.
Fourth, install WordPress by retrieving its most recent version from WordPress.org.
As of this writing, version 3.0.1 is available.
WordPress 3.0.1.zip, which you should extract to the C: drive.Computer SoftwareFoundation for Open Source Software ApacheApache2.2\htdocs
To access WordPress, navigate to C:/Program Files/Apache Software Foundation/Apache2.2/htdocs/WordPress.
wp-config-sample.php should be renamed to wp-config.php.
Change the following in wp-config.php, located in C:/Program Files/Apache Software Foundation/Apache2.2/htdocs/WordPress:
Wordpress, wpadmin, changeme, db_password, db_host, localhost, define(‘DB_NAME’, ‘WordPress’); db_user, ‘wpadmin’; db_password, ‘changeme’; db_host, ‘localhost’);
To create API keys in secret, please visit the following link. Go to WordPress.org/secret-key/1.1/salt and replace the values below with the ones generated there.
Define (‘AUTH_KEY,’ ‘put your unique phrase here’), define(‘SECURE_AUTH_KEY,’ ‘put your unique phrase here’), explain (‘LOGGED_IN_KEY,’ ‘put your unique phrase here’), present (‘NONCE_KEY’, ‘put your unique phrase here’);
Check to see if the Apache server is still active. If not, activate it.
Launch your web browser and go to:
localhost/WordPress/wp-admin/install.php
To finish installing WordPress, follow the on-screen prompts.
Viet Ma works as a programmer for Java. He is interested in internet marketing, website traffic, and search engine optimization [http://www.get-to-the-top.com]. He is willing to impart his wisdom to anyone who seeks to increase their website’s visibility and traffic.
Read also: Tips For Organizing Ad Groups In Google AdWords To Boost Click-Through Rate.