MySQL - Genome Sequence

Substring for parts of the sequence:
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_substring-index

Apache/MySQL Install

http://httpd.apache.org/docs/2.0/install.html
cd /usr/local/apache2/bin
sudo -i apachectl start

or
cd /usr/sbin
sudo -i apachectl start

http://www.cyberciti.biz/faq/how-to-install-mysql-under-rhel/

reinstall!!
rpm -qa | grep -i '^httpd-'
sudo -i rpm --allmatches --nodeps -ev mysql-server-5.0.77-4.el5_5.
kill `cat /var/run/mysqld/mysqld.pid`
mysqld_safe --init-file=/home/pmd18/passchange &

Red Hat Admin - SSHD and VNC

How do I change the default port that OpenSSH server uses?

http://magazine.redhat.com/2007/04/16/how-do-i-change-the-default-port-that-openssh-server-uses/

Tunnelling VNC over SSH with PuTTY
http://martybugs.net/smoothwall/puttyvnc.cgi

Entromics Server - Things completed today

Installed gcc, gfortran, LAPACK, BLAS, and GSL

Red Hat Admin - Install Packages

yum search package_name
yum install package_name

Red Hat Admin - New User

useradd new_username
passwd new_username
chage -d 0 new_username