mysql安装sheel脚本-优快云博客

本文提供了一个用于在Linux环境下安装MySQL 5.7的bash脚本，包括检查root权限、创建安装目录、下载并解压MySQL安装包、初始化数据库、配置环境变量及服务自启动等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

#!/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