离线安装安装mysql5.7OR8.0脚本

内容纲要
#/bin/bash
. /etc/init.d/functions
SRC_DIR=`pwd`
#MYSQL='mysql-5.7.36-linux-glibc2.12-x86_64.tar.gz'
MYSQL='mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz'
COLOR='echo -e \E[01;31m'
END='\E[0m'
MYSQL_ROOT_PASSWORD=dhtr-123


check (){

if [ $UID -ne 0 ];then
	action "当前用户不是root,安装失败"false
	exit 1
fi

cd $SRC_DIR
if [ ! -e $MYSQL ];then
	$COLOR"缺少${MYSQL}文件"$END
	$COLOR"请将相关文件放在${SRC_DOR}目录下"$END
	exit
elif [ -e /usr/local/mysql ];then
	action"数据库已存在,安装失败"false
	exit
else
	return
fi
}

install_mysql (){
	$COLOR"开始安装MYSQL数据库..."$END
	yum -y -q install libaio numactl-libs
	cd $SRC_DIR
	tar xf $MYSQL -C /usr/local/
	MYSQL_DIR=`echo $MYSQL | sed -nr 's/^(.*[0-9]).*/\1/p'`
	ln -s /usr/local/$MYSQL_DIR /usr/local/mysql
	id mysql &> /dev/null || { useradd -s /sbin/nologin -r mysql ; action "创建mysql用户";}

	echo 'PATH=/usr/local/mysql/bin/:$PATH' > /etc/profile.d/mysql.sh
	. /etc/profile.d/mysql.sh
	ln -s /usr/local/mysql/bin/* /usr/bin/
	cat > /etc/my.cnf <<-EOF
[mysqld]
server-id=1
log-bin
datadir=/data/mysql
socket=/data/mysql/mysql.sock
log-error=/data/mysql/mysql.log
pid-file=/data/mysql/mysql.pid
[client]
socket=/data/mysql/mysql.sock
EOF
[ -d /data ] || mkdir /data
mysqld --initialize --user=mysql --datadir=/data/mysql
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
service mysqld start
[ $? -ne 0 ] && { $COLOR"数据库启动失败,退出!"$END;exit; }
MYSQL_OLDPASSWORD=`awk '/A temporary password/{print $NF}' /data/mysql/mysql.log`
mysqladmin -uroot -p$MYSQL_OLDPASSWORD password $MYSQL_ROOT_PASSWORD &>/dev/null
action "数据库安装完成"
} 


check
install_mysql

安装包需自行下载,安装那个版本修改变量名称即可~

发表评论

您的电子邮箱地址不会被公开。 必填项已用 * 标注