Installing mysql in RHEL/Centos

Step 1) Adding user and group for mysql

groupadd mysql; useradd -r -g mysql mysql

step 2) download and untar mysql

cd /usr/local/

tar zxvf /usr/local/mysql-5.1.55-linux-i686-glibc23.tar.gz

step3) Creating soft link for mysql and change the permission files/directories

 ln –s /usr/local/mysql /usr/local/mysql-5.1.55-linux-i686-glibc23.tar.gz

cd mysql

chown -R mysql. *

Step4) Run mysql_install script

scripts/mysql_install_db --user=mysql

step5) copy my.cnf to /etc/my.cnf

cp support-files/my-medium.cnf /etc/my.cnf

step6) Run Mysql in safe mode

bin/mysqld_safe --user=mysql &

step 7) copy mysql init script on /etc/init.d

cp support-files/mysql.server /etc/init.d/mysql.server