一键安装Mysql单实例

07008

#!/bin/sh
################################################
#Author: Created by randolph 2016-04
#Function: This scripts function is Install MySQL
#Version:4.1.2
#################################################
. /etc/init.d/functions
uid=`id|awk -F "[=(]+" '{print $1}'`
if [ $uid -ne 0 ];then
  action "Only root can execute the script." /bin/false
  exit 1
fi
yum -y install ncurses ncurses-devel openssl-devel bison gcc gcc-c++ cmake make
useradd mysql -s /sbin/nologin -M
cd /home/zhangyiling/tools/mysql
tar zxf mysql-5.5.32.tar.gz
cd mysql-5.5.32
cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 \
-DMYSQL_DATADIR=/application/mysql-5.5.32/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.5.32/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_DEBUG=0
make && make install
    if [ $? -ne 0 ];then
    action "Install mysql is failed!"  /bin/false
exit $?
fi
sleep 2

ln -s /application/mysql-5.5.32/ /application/mysql
/bin/cp  /home/zhangyiling/tools/mysql/mysql-5.5.32/support-files/my-small.cnf /etc/my.cnf
cp /home/zhangyiling/tools/mysql/mysql-5.5.32/support-files/mysql.server /etc/init.d/mysqld
chmod 700 /etc/init.d/mysqld
echo "export PATH=/application/mysql/bin:$PATH">>/etc/profile
source /etc/profile
chown -R mysql.mysql /application/mysql/data/
/application/mysql/scripts/mysql_install_db  --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql
if [ $? -ne 0 ];then
    action "install mysql is failed!"  /bin/false
    exit $?
fi

/etc/init.d/mysqld start
if [ $? -ne 0 ];then
    action "mysql start is failed!"  /bin/false
    exit $?
fi
/application/mysql/bin/mysql -e "select version();" >/dev/null 2>&1
if [ $? -eq 0 ];then
    echo "+---------------------------+"
    echo "+------mysql安装完成--------+"
    echo "+---------------------------+"
fi