#/bin/bash
#Title:mysql_install.sh
#Description:Auto install mysql
#System:Use Linux
#Author:zy
#Version:5.1
#==========================================
. jjconfig
#:Use Mysqldir
#:Use Mysqlconf
#:Use Variable
#:Use Source
#==========================================
#Set PWD
PWDDIR=`pwd`
Check_error()
{
if [ $? -eq 0 ];then
echo "SUCCESS"
else
echo "FAIL" >>$PWDDIR/mysql.log
fi
}
Check_exist()
{
if [ -d $Mysqldir -a -f $Mysqlconf -a -f $Variable -a $Source ];then
echo "OK"
tar xvf $Source &>/dev/null
Check_error
else
echo "准备文件不足,请用户先创建好"
exit
fi
}
Install()
{
yum -y install gcc gcc-c++ ncurses-devel openssl openssl-devel libtool* &>/dev/null
Check_error
cd mysql-5.1.50
./configure '--prefix=/usr/local/mysql-5.1' '--localstatedir=/data' '--with-unix-socket-path=/usr/local/mysql-5.1/mysql.sock' '--with-charsets=utf8' '--with-extra-charsets=complex' '--with-pthread' '--enable-thread-safe-client' '--with-ssl' '--with-client-ldflags=-all-static' '--with-mysqld-ldflags=-all-static' '--with-plugins=partition,federated,ndbcluster,innobase,csv,blackhole,myisam,innodb_plugin,heap,archive' '--enable-shared' '--enable-assembler'
Check_error
make
Check_error
make install
Check_error
}
Initial()
{
groupadd mysql
useradd -g mysql -s /sbin/nologin -M mysql
if [ -f /data ];then
rm -rf /data/*
else
mkdir /data
fi
if [ -f /usr/local/mysql-5.1 ];then
rm -rf /usr/local/mysql-5.1/*
else
mkdir /usr/local/mysql-5.1
fi
chown -R mysql:mysql /usr/local/mysql-5.1
chown -R mysql:mysql /data
/usr/local/mysql-5.1/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql-5.1 --datadir=/data
Check_error
cp /usr/local/mysql-5.1/share/mysql/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
sed -i "/^basedir=$/s/.*/basedir=${Base_dir}/g" /etc/init.d/mysqld
sed -i "/^datadir=$/s/.*/datadir=${Data_dir}/g" /etc/init.d/mysqld
cp ./my.cnf /etc
Check_error
#设置环境变量
sed -i "/^MYSQL=/s/.*/MYSQL=${Mysql}/g" /etc/profile
echo 'PATH=$PATH:$MYSQL' >>/etc/profile
echo "export PATH" >>/etc/profile
source /etc/profile
}
Restart()
{
/etc/init.d/mysqld restart
Check_error
}
main()
{
echo "************************************************"
echo " 1.解压 2.编译安装 3.初始化 4.启动服务 5.退出 "
echo "************************************************"
read -p "请选择您的操作（1 2 3 4 5）" i
case $i in
1)
Check_exist;;
2)
Install;;
3)
Initial;;
4)
Restart;;
5)
exit;;
esac
main
}
main;
工作目录是dconfig,里面有三个文件:jjconfig,my.cnf和mysql-5.1.50.tar.gz
jjconfig的内容是：Mysqldir="\/scripts\/dconfig"
Mysqlconf="\/scripts\/dconfig\/my.cnf"
Variable="\/scripts\/dconfig\/jjconfig"
Source="\/scripts\/dconfig\/mysql-5.1.50.tar.gz "
Base_dir="\/usr\/local\/mysql-5.1"
Data_dir="\/data"
Mysql="\/usr\/local\/services\/mysql\/bin"
~
my.cnf的内容：
[ mysqld ]
datadir = /data
basedir = /usr/local/mysql-5.1
socket = /usr/local/mysql-5.1/mysql.sock
~
