#!/bin/bash
if [ "$(pwd)" != "/opt" ]; then
echo "请确保脚本和安装包都已放在/opt目录下,然后再运行脚本。"
exit 1
fi
# 检查当前用户是否为root
if [ "$(id -u)" != "0" ]; then
echo "该脚本必须以root用户运行"
exit 1
fi
# 检查并安装依赖项
for package in libaio numactl net-tools; do
rpm -q $package || yum install -y $package
if [ $? -ne 0 ]; then
echo "在线安装依赖项${package}失败,尝试离线安装"
# 挂载光盘
mount /dev/cdrom /mnt/
if [[ $? -ne 0 ]]; then
echo "挂载光盘失败"
exit 1
fi
# 备份原有yum源配置文件
mv /etc/yum.repos.d/* /etc/yum.repos.d/backup/
mv /etc/yum.repos.d/backup/CentOS-Media.repo /etc/yum.repos.d/
# 编辑CentOS-Media.repo文件
sed -i 's/enabled=0/enabled=1/g' /etc/yum.repos.d/CentOS-Media.repo
sed -i 's!media/!mnt/!' /etc/yum.repos.d/CentOS-Media.repo
# 清空缓存并创建新缓存
yum clean all
yum makecache
# 使用本地源进行安装
yum install -y $package
if [ $? -ne 0 ]; then
echo "离线安装依赖项${package}失败,请检查你的光盘设置"
exit 1
fi
fi
done
# 检查是否已经安装了MySQL
which mysql > /dev/null 2>&1
if [ $? -eq 0 ]; then
echo "MySQL已经安装"
exit 1
fi
# 进入/opt目录并查找包含mysql的tar文件
cd /opt
mysql_tar_files=($(ls | grep mysql | grep .tar))
case ${#mysql_tar_files[@]} in
0)
# 如果没有找到包含mysql的tar文件, 列出所有的tar文件
all_tar_files=$(ls | grep .tar)
echo "没有找到包含'mysql'的tar文件,以下是所有的tar文件:"
echo "$all_tar_files"
;;
1)
# 如果只找到一个包含mysql的tar文件,直接使用
tarfile="${mysql_tar_files[0]}"
;;
*)
# 如果找到了多个包含mysql的tar文件, 显示出来并提示用户选择
echo "找到多个包含'mysql'的tar文件,请选择一个:"
select tarfile in "${mysql_tar_files[@]}"; do
if [[ " ${mysql_tar_files[@]} " =~ " ${tarfile} " ]]; then
break;
fi
echo "无效的选择"
done
esac
# 解压用户选择的tar文件
tar -xvf $tarfile
# 卸载可能会冲突的mariadb
rpm -qa | grep mariadb
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
# 提示用户输入rpm包的基础名称
read -p '请输入rpm文件的基础名称(不包含版本或扩展名): ' rpmname
# 安装mysql
rpm -ivh ${rpmname}-common-*.rpm
rpm -ivh ${rpmname}-libs-*.rpm
rpm -ivh ${rpmname}-libs-compat-*.rpm
rpm -ivh ${rpmname}-client-*.rpm
rpm -ivh ${rpmname}-server-*.rpm
rpm -ivh ${rpmname}-devel-*.rpm
# 如果安装失败,显示错误信息并退出
if [ $? -ne 0 ]; then
echo "MySQL安装失败"
exit 1
fi
# 初始化mysql
mysqld --initialize --user=mysql
# 获取临时密码
temp_password=$(grep 'temporary password' /var/log/mysqld.log)
# 检查是否成功获取临时密码
if [ -z "$temp_password" ]; then
echo "无法获取临时密码,MySQL安装失败"
exit 1
fi
echo "你的临时密码是: ${temp_password}"
# 启动mysql
systemctl start mysqld
echo "请在/etc/my.cnf文件中的[mysqld]下添加如下行:"
echo "character-set-server=utf8"
echo "安装完成。你可以使用以下命令登录并修改密码:"
echo "mysql -uroot -p'"
echo "${temp_password}"
echo "'然后执行 ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; 来修改密码。"
echo "并且执行 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; 以允许远程连接。"
本文由 mdnice 多平台发布