Mysql数据库脚本一键编译安装(5.7.42)

```
SRC_DIR="/usr/local/src"
MYSQL="mysql-5.7.42-linux-glibc2.12-x86_64.tar.gz"
DATA="/data/mysql"
COLOR="echo -e \E[32;1m"
END="\E[0m"

$COLOR"开始安装MySQL数据库"$END
tar xvf $MYSQL -C $SRC_DIR
ln -s `echo $MYSQL | sed -r "s#(.*[0-9]).*#\1#g"` $SRC_DIR/mysql
id mysql &> /dev/null || { useradd -s /sbin/nologin -r  mysql; $COLOR"创建mysql用户"$END; }
mkdir -p $DATA
chown -R mysql.mysql $DATA
chown -R mysql.mysql $SRC_DIR/mysql/*
echo "PATH=$PATH:$SRC_DIR/mysql/bin" > /etc/profile.d/lamp.sh
source /etc/profile.d/lamp.sh

$COLOR"开始初始化数据库"$END
yum  -y install libaio-devel
$SRC_DIR/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=$SRC_DIR/mysql --datadir=$DATA
cat >/etc/my.cnf<<-EDF
[mysqld]
user=mysql
basedir=$SRC_DIR/mysql
datadir=$DATA
socket=/tmp/mysql.sock         
port=3306
skip_name_resolve=1
log-error=$DATA/mysql.log
pid-file=$DATA/mysql.pid
[mysql]
socket=/tmp/mysql.sock
EDF

cat >/etc/systemd/system/mysqld.service<<-EOF 
[Unit]
Description=MySQL Server
After=network.target
After=syslog.target
[Install]
WantedBY=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=$SRC_DIR/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
EOF
systemctl daemon-reload
systemctl enable --now mysqld.service
systemctl is-active mysqld.service &>/dev/null || { $COLOR"MYSQL 启动失败,退出!"$END ; exit; }
$COLOR"MYSQL安装完成~~请ctrl+D重新远程连接,加载PATH变量!!!"$END

```