MYSQL5.5.19源码安装脚本

#!/bin/sh
#install mysql5.5.19

echo "nameserver 8.8.8.8">>/etc/resolv.conf

yum install -y gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt*  cmake
#wget http://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.19.tar.gz

if [ -d /app/mysql55 ];then
rm -rf /app/mysql55
fi
if [ -l /usr/local/mysql55 ];then
rm -rf /usr/local/mysql55
fi

mkdir -p  /app/mysql55
ln -s /app/mysql55 /usr/local
cd /app/mysql55
tar zxvf /root/mysql-5.5.19.tar.gz
cd mysql-5.5.19
cmake -DCMAKE_INSTALL_PREFIX=/app/mysql55
make &&  make install

cd /app/mysql55
chown -R mysql:mysql .
chmod +x /app/mysql55/scripts/mysql_install_db
scripts/mysql_install_db --user=mysql
chown -R root .
chown -R mysql:mysql data
#cp support-files/my-medium.cnf /etc/my.cnf
cp /root/my55.cnf  /etc/my.cnf

lastip=`ifconfig eth0|grep -i -w "inet"|awk '{print $2}'|awk -F'.' '{print $3$4}'`
sed -i 's/ifconfigeth/'$lastip'/g' /etc/my.cnf

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

echo '/usr/local/mysql55/bin/mysqld_safe --user=mysql &'>>/etc/rc.local

bin/mysqld_safe --user=mysql &
service mysql.server restart
/usr/local/mysql55/bin/mysqladmin -uroot password 'mysq'
##增加一个只读的search账号,宁外为中心监控机增加一个账号
/usr/local/mysql55/bin/mysql -uroot -pmysql -e "
------------

flush PRIVILEGES
"

echo "PATH=$PATH:/usr/local/mysql55/bin" >>/etc/bashrc
echo "export PATH"                     >>/etc/bashrc