mysql安装sheel脚本

#!/bin/bash

if [ "$(whoami)" != 'root' ]; then
 echo "You  have no permission to run $0 as non-root user."
 exit 1;
fi

INDIR=/opt/software
if [ ! -d "$INDIR" ]; then
  mkdir -p $INDIR
  echo "create dir install"
fi
yum -y install numactl libaio-devel.x86_64 libaio

cd $INDIR
echo "dir is:"$(pwd)
#echo "DOWNLOADING mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz"
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
echo "Install mysql Server"
tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.26-linux-glibc2.12-x86_64 mysql
cd mysql
echo "groupadd mysql and user mysql"
groupadd mysql
useradd -r -g mysql mysql
chown -R mysql.mysql mysql
yum -y install numactl
./bin/mysqld --initialize --user=mysql --basedir=$INDIR/mysql --datadir=$INDIR/mysql/data
sleep 30

#config my.cnf
wget http://axe555.1024xyz.xyz/wget/my.cnf
mkdir -p binlog_relay binlog_data logs
chown -R mysql.mysql ./*
wget http://axe555.1024xyz.xyz/wget/mysql.server
chmod 755 ./mysql.server

#start mysql
nohup ./bin/mysqld --defaults-file=./my.cnf>>./nohup.out 2>&1 &

while true
do
        result=$(netstat -na | grep 2849 | wc -l)
        if [ $result == 0 ]; then
        echo "mysql starting,pleale wait ......."
        sleep 2
        else
        echo "mysql started"
        break;
        fi
done

echo "please running command :"\"./bin/mysql_secure_installation\" "for change password and Initialization configuration"
echo "-----running Directory:"$INDIR"/mysql"

#config mysql env
cat >> /etc/profile <<EOF

#mysql env
export MYSQL_HOME="$INDIR/mysql"
export PATH="\$PATH:\$MYSQL_HOME/bin"

EOF
source /etc/profile
cd ..
source /etc/profile

#添加mysql服务和开机自启动
cp /opt/software/mysql/mysql.server /etc/init.d/mysqld
chkconfig --add /etc/init.d/mysqld

#start firewall mysql port
sed -i '/service name="ssh"/a <port protocol="tcp" port="2849"/>' /etc/firewalld/zones/public.xml
firewall-cmd --reload