mysql

• download source from http://dev.mysql.com (version 5)

(create a mysql user)

./configure --prefix=/usr/local/mysql --mandir=/usr/local/man --infodir=/usr/local/info

make

sudo make install

sudo cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf
(modify /etc/my.cnf as desired)

cd /usr/local/mysql
sudo chown -R mysql:mysql .

(if you have not installed MySQL before, you must create the MySQL data directory and initialize the grant tables)
sudo /usr/local/mysql/bin/mysql_install_db --user=mysql
sudo chown -R root .
sudo chown -R mysql var

(start the MySQL server)
sudo /usr/local/mysql/bin/mysqld_safe --user=mysql &

(setup a password for root)
sudo /usr/local/mysql/bin/mysqladmin -u root password 'new-password'

(shutdown the MySQL server)
sudo /usr/local/mysql/bin/mysqladmin -u root -p shutdown