Utilizing Linux, Apache, MySQL, and PHP For Software Deployment

This tutorial will also cover common MySQL syntax, so that a server administrator can troubleshoot difficulties within just a specific application. It’s really beneficial.
* Enter a new root password and do NOT test “Allow root access from remote machines” and “Develop An Anonymous Account” seeing that these two choices will generate safety loophole.
* Click “Execute” and it will set up MySQL on your local machine.

Start MySQL and create a new database for your WordPress installation. You will need to present an correct title for your database. In this tutorial, I identify the database as “WordPress” and the admin person as “wpadmin”. Improve it to whatever you like.ke.

Open your terminal (MS DOS or cygwin) and execute the following commands:

$ mysql -u root -p
Enter password: ********

mysql> build database WordPress
Query Ok, one row impacted (.03 sec)

mysql> grant all on WordPress.* to wpadmin @localhost identified by ‘changeme’
Query Okay, rows impacted (.03 sec)

mysql> flush privileges
Query Ok, rows impacted (.02 sec)

mysql> exit
Bye

2. Apache setup:
Download Apache 2.2 at apache.org
My downloaded file is httpd-2.two.15-win32-x86-no_ssl.msi
Run the MSI file and use the subsequent settings:
* Network Domain: localhost
* Server Name: localhost
* Administrator’s E mail Deal with: youremail @e mail.com
* Make certain “for All Users” is checked.
* Standard Setup Style
* Hit “Install” and it will setup Apache on your neighborhood machine.

Soon after the set up completes, go to Management Panel -> Administrative Instruments -> Services, seem for the “Apache2.2” service and double-click on it.
From the following you can stop the support and modify the startup type to “Manual”

Configure Apache:

Open and modify the httpd.conf at C:\Program Files\Apache Program Foundation\Apache2.2\conf as below:
Uncomment the subsequent line:
LoadModule rewrite_module modules/mod_rewrite.so
Add:
LoadModule php5_module “C:/php/php5apache2_2.dll”
Search for
Exchange:
AllowOverride None
With:
AllowOverride All

Add index.php to DirectoryIndex as below:
DirectoryIndex index.php index.html

Locate and add:
AddType software/x-httpd-php.php.phtml

Include this line to the conclusion of httpd.conf
PHPIniDir “C:/php”

Restart Apache to make the up-to-date configuration useful.

3. PHP setup:
Download PHP five.two.13 at php.internet
My downloaded file is php-five.two.thirteen-Win32.zip
Unzip the downloaded bundle to C:\php

Duplicate C:\php\libmysql.dll to C:\WINDOWS\system32
Duplicate C:\php\php.ini-suggested and rename it as php.ini

Open and modify the recently copied C:\php\php.ini
Uncomment:
extension_dir = “ext”
extension=php_gd2.dll (this is employed for CAPTCHA)
extension=php_mysql.dll
extension=php_mysqli.dll

Add:
day.timezone = “Australia/Melbourne”

four. WordPress setup:
Download the newest model of WordPress at WordPress.org
At the time of this composing, it is version 3..one
Download and unzip WordPress-three..1.zip to C:\Program Files\Apache Computer software Foundation\Apache2.2\htdocs

Go to C:/System Files/Apache Software Foundation/Apache2.two/htdocs/WordPress
Rename wp-config-sample.php to wp-config.php

Update wp-config.php at C:/Program Files/Apache Program Foundation/Apache2.two/htdocs/WordPress with the following configurations:
outline(‘DB_NAME’, ‘WordPress’)
outline(‘DB_USER’, ‘wpadmin’)
define(‘DB_PASSWORD’, ‘changeme’)
outline(‘DB_HOST’, ‘localhost’)

Click the subsequent link to create solution keys api.WordPress.org/key-critical/1.1/salt and substitute the following values with the created keys from that website link.

define(‘AUTH_KEY’, ‘put your special phrase here’)
define(‘SECURE_AUTH_KEY’, ‘put your unique phrase here’)
define(‘LOGGED_IN_KEY’, ‘put your exclusive phrase here’)
define(‘NONCE_KEY’, ‘put your unique phrase here’)