自动安装Mysql

#!/bin/bash
#set env
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
export PATH
#install need root user.
if [ `whoami` != "root" ];then
        echo "Installtion this package needs root user."
        exit 1
fi
#ver
mysql_ver="5.1.53"
#
which dialog >/dev/null 2>&1
if [[ $? -ne 0 ]]
then
echo "yum install -y dialog";
yum install -y dialog;
fi
#download software
mkdir -p /root/installtemp/packages
cp /root/packages/mysql-5.1.53.tar.gz /root/installtemp/packages/
if [ -s /root/installtemp/packages/mysql-${mysql_ver}.tar.gz ]; then
  echo "$i [found]"
else
  echo "Error: $i not found!!!download now......"
  exit 1
fi
#complier mysql
cd /root/installtemp/packages
tar zxvf mysql-${mysql_ver}.tar.gz
cd mysql-${mysql_ver}

/usr/sbin/groupadd mysql -g 27
/usr/sbin/useradd -u 27 -g mysql -c "MySQL Server" mysql -s /sbin/nologin

#autoreconf --force --install
#libtoolize --automake --force
#automake --force --add-missing
#CHOST="x86_64-pc-linux-gnu"
#CFLAGS="-march=nocona -O3 -pipe"
#CXXFLAGS="${CFLAGS}"

CXX=gcc \
CHOST="x86_64-pc-linux-gnu" \
CFLAGS=" -O3 \
-fomit-frame-pointer \
-pipe \
-march=nocona \
-mfpmath=sse \
-m128bit-long-double \
-mmmx \
-msse \
-msse2 \
-maccumulate-outgoing-args \
-m64 \
-ftree-loop-linear \
-fprefetch-loop-arrays \
-freg-struct-return \
-fgcse-sm \
-fgcse-las \
-frename-registers \
-fforce-addr \
-fivopts \
-ftree-vectorize \
-ftracer \
-frename-registers \
-minline-all-stringops \
-fbranch-target-load-optimize2" \
CXXFLAGS="${CFLAGS}" \
./configure --prefix=/usr/local/mysql-${mysql_ver} --with-server-suffix=-LTOPS \
--with-plugins=partition,blackhole,csv,heap,innobase,myisam,myisammrg \
--with-charset=utf8 --with-collation=utf8_general_ci \
--with-extra-charsets=gbk,gb2312,utf8,ascii --with-big-tables \
--with-fast-mutexes --with-zlib-dir=bundled --enable-assembler \
--enable-profiling --enable-local-infile --enable-thread-safe-client \
--with-readline --with-pthread --with-embedded-server \
--with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static \
--without-geometry --without-debug --without-ndb-debug

make -j8 && make install

chmod +w /usr/local/mysql-${mysql_ver}/
chown -R mysql:mysql /usr/local/mysql-${mysql_ver}/
cd

mkdir -p /data/mysql/3306/{data,logs/{binlog,relaylog}}
#mkdir -p /data/mysql/3307/{data,logs/{binlog,relaylog}}
#mkdir -p /data/mysql/3308/{data,logs/{binlog,relaylog}}
chown -R mysql:mysql /data/mysql/
#copy cnf and scripts.
cp /root/packages/conf/my.cnf /data/mysql/3306/
cp /root/packages/conf/mysql.sh /data/mysql/3306/mysql

chown -R mysql:mysql /data/mysql/
rm -rf /etc/my.cnf
ln -s /data/mysql/3306/my.cnf /etc/my.cnf

/usr/local/mysql-${mysql_ver}/bin/mysql_install_db --basedir=/usr/local/mysql-${mysql_ver}/ --datadir=/data/mysql/3306/data --user=mysql --defaults-file=/data/mysql/3306/my.cnf

#setting start scripts
cp /root/installtemp/packages/mysql-${mysql_ver}/support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod 755 /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
/etc/rc.d/init.d/mysqld start > /dev/null 2>&1

cd /usr/local/mysql-${mysql_ver}/bin/

for i in `ls /usr/local/mysql-${mysql_ver}/bin/`;do
 rm -rf /usr/bin/$i
 ln -s /usr/local/mysql-${mysql_ver}/bin/$i /usr/bin/$i
done

echo "---------------------------------------------------------"
pwd
cd -
echo "--------------------------------------------------------"
pwd

#ask password
#mysqlrootpwd="admin"
if [ "$mysqladminpwd" = "" ]; then
      mysqladminpwd=""
fi
printf "\n"
#setting password
#exec 4>&1 ;mysqladminpwd=$(dialog --title "Setting MySQL root Password" --backtitle "????" --inputbox "Enter Password for MySQL root:" 8 60 2>&1 1>&4);exec 4>&-
mysql -S /tmp/mysql.sock -e "GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY '${mysqladminpwd}'"
mysql -S /tmp/mysql.sock -e "GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY '${mysqladminpwd}'"
mysqladmin create account
mysqladmin create character
mysqladmin create gamedata
echo
echo "project db is create ok!"

#sed -i "/mysql_password=/ {s/.*/mysql_password=\"${mysqladminpwd}\"/}" /etc/init.d/mysql
echo -en "\033[39;49;0m"
echo "All is done!"
echo "Your password root : ${mysqladminpwd}"
echo "You Can input : mysql -uroot -p${mysqladminpwd}"