单主机二进制部署mysql-5.7.25

#!/bin/bash

# 时间：
# 项目：单主机二进制部署mysql
# 1.创建目录
mkdir -p /data/mysql  &>/dev/null
# 2.创建用户
useradd -s /sbin/nologin -M mysql   &>/dev/null
# 3.下载并且解压软件包
mkdir -p /opt/src
cd /opt/src/
if [ ! -f "mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz" ];then
    wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz 
    tar xf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
    elif [ ! -d "mysql-5.7.25-linux-glibc2.12-x86_64" ];then
        tar xf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
    else
    echo "already exists"
fi
# 4.创建软链接
ln -s `pwd`/mysql-5.7.25-linux-glibc2.12-x86_64 /opt/mysql &>/dev/null
# 5.配置环境变量
cat >> /etc/profile << EOF
export PATH=/opt/mysql/bin:\$PATH
EOF

source /etc/profile
sleep 3
# 6.给目录授权
chown -R mysql:mysql /data/mysql/
chown -R mysql:mysql /opt/mysql
# 7.清理环境
yum -y remove `rpm -qa |grep mariadb` &>/dev/null
# 8.初始化数据库——没有密码
mysqld --initialize-insecure --user=mysql  --basedir=/opt/mysql  --datadir=/data/mysql &>/dev/null
# 9.编写配置文件
cat >/etc/my.cnf <<EOF
[mysqld]
user=mysql
basedir=/opt/mysql
datadir=/data/mysql
server_id=6
port=3306
socket=/tmp/mysql.sock
[mysql]
socket=/tmp/mysql.sock
EOF
# 10.配置启动脚本
cat > /etc/systemd/system/mysqld.service <<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/opt/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
EOF
# 11.启动mysql
systemctl daemon-reload
systemctl start mysqld.service
systemctl status mysqld.service
mysql -V

# 11.密码修改
# mysqladmin -uroot -p password 123456
# ================================脚本结束================================