JSP - Johnson's Server Project
FIREWALL - Database

packages Install packages
mysql-client-4.0.18.tgz
mysql-server-4.0.18.tgz
These installs will most likely call for other installs
Initialize
/usr/local/bin/mysql_install_db --user=_mysql
(We want the directories and files to be owned by user _mysql so the server has read and write access to them)
Passwords
/usr/local/bin/mysqld_safe --user=_mysql & //this starts the server
/usr/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h openserve.jsp password 'new-password'
Startup on boot add the following lines to /etc/rc.local
#
# Starts MySQL server at boot (Not the prettiest method, but it works.)
#
/usr/local/bin/mysqld_safe --user=_mysql &
Is the server running? type fstat | grep "*:" | grep mysql
you should see the following:
_mysql mysqld 22190 5* internet stream tsp 0xd0bc25a4 *:3306
or something like that
This shows that the mysql daemon (mysqld) is running with user privileges of _mysql and listening on port 3306