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


 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值