Compiling MySQL Server

We will need a MYSQL server because courier-authlib need a mysql client library on this installation and the other reason is if we want to install postfix MTA to support MySQL Db this should be done with these steps below.

Installing MySQL Server

cd /root/postfixrocks/
tar -zxvf mysql-5.1.44.tar.gz
cd mysql-5.1.44
./configure --prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/var \
--with-pthread --with-big-tables
make && make install

Change mysql dir permission

chown -R mysql.mysql /usr/local/mysql

Copy mysql cnf files from this directory below to /etc/and change the file to my.cnf

cd /usr/local/mysql/share/mysql
cp my-small.cnf /etc/my.cnf

Install mysql DB

/usr/local/mysql/bin/mysql_install_db --user=mysql

Starting mysql server

/usr/local/mysql/bin/mysqld_safe --user=mysql &

Create mysql root password

/usr/local/mysql/bin/mysqladmin -u root password 'new-password'

Add MySQL into boot.local

echo "/usr/local/mysql/bin/mysqld_safe --user=mysql &" >> /etc/init.d/boot.local