FAMP (FreeBSD, Apache, MySQL, PHP)

[Edit]I have an updated version of this article here[/Edit]


It's extremely easy to set up a PHP-aware web server in FreeBSD. Here's a quick how-to using the FreeBSD's ports system. The advantage of using the ports system is that updating the server is painless when new versions of the software come out. We'll install the latest version of Apache 1.3, the latest version of MySQL 4.0 and the latest version of PHP 5.

MySQL
Install MySQL first:

cd /usr/ports/databases/mysql40-server
make install clean


Apache
Install Apache with SSL support:

cd /usr/ports/www/apache13-modssl
make
make certificate

Follow the prompts to create the certificate. When you’re done, continue with the installation:

make install
make clean


PHP5
To install mod_php5:

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

Install PHP extensions (e.g MySQL support):

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

A ncurses menu will appear. Select whatever you need from the options.


Post-Installation Configuration
Edit the Apache configuration file /usr/local/etc/apache/httpd.conf and add these lines in the file:

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

Look through the file and edit the configuration to suit your needs. Next create a php.ini configuration file from the php.ini-recommended example configuration:

cd /usr/local/etc
cp php.ini-recommended php.ini

Again, look through the configuration file and see if you want to change anything. Next, configure your MySQL server. By default, no password is set for the MySQL root user. You should set a password for that user at this point:

mysqladmin -u root password "newpassword"

Replace "newpassword" with your own. MySQL comes with two anonymous accounts set up. These accounts don't have any passwords assigned by default. It is a good idea to just delete them. At the MySQL prompt, issue the following command:

delete from mysql.user where user = '';
flush privileges;

You may want to use a tool such as MySQL Administrator from a workstation on your network. In order to connect to the MySQL server from your network, you need to give the user whom you want to connect as the required priviledges. For example:

GRANT ALL ON *.* TO root@'192.168.0.%' IDENTIFIED BY 'yourPass';

To exit from the MySQL prompt, just type "exit".

Controlling your servers
You can start, stop or restart Apache by issuing the following commands:

/usr/local/etc/rc.d/apache.sh start
/usr/local/etc/rc.d/apache.sh stop
/usr/local/etc/rc.d/apache.sh restart

You can start or stop the MySQL server by doing:

/usr/local/etc/rc.d/mysql-server.sh start
/usr/local/etc/rc.d/mysql-server.sh stop

The system will use the apache.sh and mysql-server.sh scripts to start Apache and MySQL the next time you reboot as well.


References
http://dev.mysql.com/doc/mysql/en/Default_privileges.html