脚本安装MySQL

脚本安装MySQL

[root@localhost src]# ls | grep mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz 
mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz
[root@localhost ~]# vim mysql.sh
#!/bin/bash
# 安装yum源和epel源
cd /etc/yum.repos.d/
curl -o /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-vault-8.5.2111.repo &>/dev/null
sed -i -e '/mirrors.cloud.aliyuncs.com/d' -e '/mirrors.aliyuncs.com/d' /etc/yum.repos.d/CentOS-Base.repo
yum install -y https://mirrors.aliyun.com/epel/epel-release-latest-8.noarch.rpm &>/dev/null
sed -i 's|^#baseurl=https://download.example/pub|baseurl=https://mirrors.aliyun.com|' /etc/yum.repos.d/epel* &>/dev/null
sed -i 's|^metalink|#metalink|' /etc/yum.repos.d/epel* &>/dev/null
echo "yum源安装完成"
#关闭防火墙和selinux
systemctl stop firewalld
systemctl disable firewalld
#临时关闭selinux
setenforce 0
#永久关闭selinux
sed -i '/^SELINUX=/ s/enforcing/disabled/' /etc/selinux/config
echo "防火墙配置完成"
#安装依赖包
dnf -y install ncurses-devel openssl-devel openssl cmake ncurses-compat-libs  &>/dev/null
echo "依赖包安装完成"
#创建用户
id mysql &>/dev/null
if [ $? -eq 0 ];then
	echo "用户存在"
else
	useradd -M -r -s /sbin/nologin/ mysql
fi
echo "用户创建完成"
#解压软件包
cd /usr/src/
tar -xzf mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz -C /usr/local/ &>/dev/null
cd /usr/local/
ln -s mysql-5.7.37-linux-glibc2.12-x86_64/ mysql
chown -R mysql.mysql /usr/local/mysql
echo "安装包完成"
#配置环境变量
echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
ln -s /usr/local/mysql/include/ /usr/include/mysql
echo '/usr/local/mysql/bin/' > /etc/ld.so.conf.d/mysql.conf
source /etc/profile.d/mysql.sh
ldconfig
echo "环境变量配置完成"
#创建数据存放目录
mkdir /opt/data
chown -R mysql.mysql /opt/data/
echo "创建完成"
#初始化数据库
mysqld --initialize --user=mysql --datadir=/opt/data/ &>/dev/null
echo "初始化完成"
#修改配置文件
cat > /etc/my.cnf <<EOF
[mysqld]
basedir = /usr/local/mysql
datadir = /opt/data
socket = /tmp/mysql.sock
port = 3306
pid-file = /opt/data/mysql.pid
user = mysql
skip-name-resolve
EOF
sed -ri 's#^(basedir=).*#\1/usr/local/mysql#g' /usr/local/mysql/support-files/mysql.server
sed -ri 's#^(datadir=).*#\1/opt/data#g' /usr/local/mysql/support-files/mysql.server
echo "配置完成"
#配置systemd启动服务
cat > /usr/lib/systemd/system/mysqld.service <<EOF
[Unit]
Description=mysqld server daemon
After=network.target sshd-keygen.target

[Service]
Type=forking
ExecStart=/usr/local/mysql/support-files/mysql.server  start
ExecStop=/usr/local/mysql/support-files/mysql.server  stop
ExecReload=/bin/kill -HUP $MAINPID

[Install]
WantedBy=multi-user.target
EOF
systemctl daemon-reload
systemctl start mysqld.service
echo "启动服务"
#修改密码
read -p"数据库密码:" sb
mysql -uroot -e "set password = password('$sb')"
echo "修改完成"

[root@localhost ~]# source mysql.sh 
yum源安装完成
防火墙配置完成
依赖包安装完成
用户存在
用户创建完成
ln: 无法创建符号链接'/usr/local/mysql/mysql-5.7.37-linux-glibc2.12-x86_64': 文件已存在
安装包完成
环境变量配置完成
mkdir: 无法创建目录 “/opt/data”: 文件已存在
创建完成
初始化完成
配置完成
启动服务
数据库密码:1
修改完成
[root@localhost local]# mysql -uroot -p1
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.37 MySQL Community Server (GPL)

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>