1. Login to the FreeBSD system as root, or su - root to get to super user environment.

2. Enter the following commands at FreeBSD command line interface (CLI) (Wait till each command to finish processing before running the next command):

   cd /usr/ports/databases/mysql50-server
   make install clean
   mysql_install_db
   chown -R mysql /var/db/mysql/
   chgrp -R mysql /var/db/mysql/
   /usr/local/bin/mysqld_safe -user=mysql &

   Note: If you encounter Command not found error, use command rehash to update OS path environment variables.

3. The port installation will put a script file mysql-server.sh in /usr/local/etc/rc.d which will has capability to start MySQL server. To enable MySQL server to start automatically after every FreeBSD server reboot, enter the following command in CLI:

   echo ‘mysql_enable=”YES”‘ >> /etc/ rc.conf

4. By default, MySQL default super user account - root - has no password (blank password). So it’s important to assign the administrator account password. To change the password to root user, enter the following command:

   mysqladmin -u root password newpassword

   Replace newpassword with your own desired password.

5. Optionally, copy either my-huge.cnf, my-large.cnf, my-medim.cnf, my-small.cnf or my-innodb-heavy-4G.cnf (depending on the usage and utilization of MySQL server) as my.cnf to /var/db/mysql which will enable you to tweak and change the configuration of server-specific MySQL server options by editing the file.
6. MySQL 5.0 installation done.

------------------------------------------------------------------------

Installing Apache HTTPD Web Server 2.2

1. Install Apache HTTP Server 2.20 by using FreeBSD Ports Collection:

   cd /usr/ports/www/apache22
   make install clean

2. A Apache HTTP Server script apache22.sh is located at /usr/local/etc/rc.d to provide Apache HTTP Server start and shutdown service. To enable Apache web server to automatically starts whenever after server reboots, issue the following command at CLI:

   echo ‘apache22_enable =”YES”‘ >> /etc/ rc.conf

3. To start Apache HTTP web server immediately, use:

   /usr/local/sbin/apachectl start

   or

   /usr/local/etc/rc.d/apache22.sh start

4. Apache installation finished.

------------------------------------------------------------------------

Installing PHP Hypertext Preprocessor Scripting Language 5 and PHP 5 Extensions

1. Install by enter the following commands on FreeBSD OS command line, wait for previous command to finish before running the next command:

   cd /usr/ports/lang/php5
   make install clean

2. If you’re prompted, select “use Apache 2.x instead”.
3. Continue with the following commands to install PHP5 extensions and modules to enable the support of the modules in Apache:

   cd /usr/ports/lang/php5-extensions
   make config

4. At Options for php5-extension 1.0 menu, select all PHP extensions and modules that you may use with Apache webserver. This is a part of the configuration for PHP, where you need to enable features of PHP that come in modules, such as ability to manage user sessions, interface with databases and many others. Default extensions such as ctype functions support, HASH Message Digest Framework support, session support and etc have been selected. Other popular extensions that you most likely to be in used are MySQL database support and GD library support. Use space bar to select or unselect the extensions and press Enter when done.
5. Continue the installation of php5-extensions with the following commands:

   make install clean

6. If there are any message the pops up and prompts you to select some options or configurations, you can just accept the default settings by pressing Enter. Some modules that may prompt you for action include php5-gd, php5-mbstring and php5-sqlite.
7. Edit the Apache configuration file in order to enable Apache web server to load the PHP modules when initialization:
   1. Go to Apache configuration file location by cd /usr/local/etc/apache2/
   2. Edit Apache configuration file by vi httpd.conf
   3. Search for LoadModule lines, after the last LoadModule line, but within the same section, add the following 2 lines:

      AddType application/x- httpd-php .php
      AddType application/x- httpd-php-source .phps

8. Optionally, copy /usr/local/etc/php.ini-recommended or /usr/local/etc/php.ini-dist to /usr/local/etc/php.ini (in same directory), which will enable you to tune and change the default settings of behaviours of PHP.
9. Start the Apache HTTP web server by using apachectl start (or restart Apache HTTP web server by using apachectl restart). apachectl is located in /usr/local/sbin, if you encounter Command not found problem, try to change directory to its location.
10. PHP5 installation done.

A web server has been setup with the FreeBSD with Apache, MySQL and PHP. The document root of the web server (where you should put your HTML and PHP files is at /usr/local/www/apache22/data/ and you will need a SecureFTP (SFTP) client such as WinSCP to upload your files to web server securely.