脚本安装Mysql5.6

#!/bin/bash

# author: limaoshun
# data: 2020-05-24
# descript: install mysql

set -u

cd

yum -y install autoconf numactl

mysql_file=/root/mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz

[ ! -e $mysql_file ] && wget http://mirrors.163.com/mysql/Downloads/MySQL-5.6/mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz

if [ ! -e $mysql_file ];then
    echo "not found $mysql_file!" 
	exit  
fi

basedir=/data/mysql

if [ ! -d $basedir ];then
    mkdir -p $basedir
fi
   
tar -zxf $mysql_file -C $basedir

cd $basedir
mv mysql-5.6.46-linux-glibc2.12-x86_64 mysql
grep mysql /etc/passwd

if [ $? -eq 1 ];then
    useradd -M -s /sbin/nologin mysql 
fi

datadir=$basedir/data
mkdir $datadir
chown -R mysql:mysql $basedir $datadir
cd $basedir/mysql
./scripts/mysql_install_db --user=mysql --basedir=$basedir/mysql --datadir=$datadir

mysqld=/etc/rc.d/init.d/mysqld
cp ./support-files/mysql.server $mysqld

if [ -e $mysqld ];then
    sed -i "s#basedir=#basedir=$basedir/mysql#" $mysqld
	sed -i "s#datadir=#datadir=$datadir#" $mysqld
fi

touch $datadir/mysql_error.log $datadir/mysqld.pid
chown mysql.mysql $datadir/mysql_error.log $datadir/mysqld.pid

cnf=/etc/my.cnf

[ -e $cnf ] && mv /etc/my.cnf /etc/my.cnf.bak

if [ ! -e $cnf ];then
	cat >$cnf<<EOF
[mysqld]

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
basedir=$basedir/mysql
datadir=$datadir
bind-address=127.0.0.1

log-error=$datadir/mysql_error.log
pid-file=$datadir/mysqld.pid
EOF
fi

if [ -z "`ps -ef|pgrep mysqld`" ];then
	# service mysqld start
	$basedir/mysql/bin/mysqld_safe &
	sleep 3
fi

if [ -z "`ps -ef|pgrep mysqld`" ];then
	echo "start mysqld error"
else
	echo "Done"
fi

```bash
在这里插入代码片

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值