1、下载MySQL包
# 下载地址
https://downloads.mysql.com/archives/community/
# 下载rpm包
# 例如 mysql-8.0.36-1.el8.x86_64.rpm-bundle.tar
2、安装MySQL,install.sh
#!/bin/bash
# 安装的 MySQL 版本
version='8.0.36-1.el8.x86_64'
user=mysql
dbrpm_dir=/opt/mysql-rpm
echo "##### 创建MySQL用户 #####"
id $user &> /dev/null
if [ $? -eq 0 ];then
echo "$user 已存在"
else
useradd -M -s /sbin/nologin $user &> /dev/null
echo "$user 创建成功"
fi
echo "##### 清理mariadb #####"
yum remove mariadb-libs -y >/dev/null 2>&1
echo "##### 解压MySQL文件 #####"
if [ ! -d "$dbrpm_dir" ]; then
mkdir -p "$dbrpm_dir"
fi
tar -xf mysql-$version.rpm-bundle.tar -C $dbrpm_dir
if [ $? -ne 0 ]
then
echo -e "\033[31m tar xvf 'mysql' failed\033[0m"
exit 1
fi
cd $dbrpm_dir
if [ $? -ne 0 ]
then
echo -e "\033[31m cd "$dbrpm_dir" failed\033[0m"
exit 1
fi
echo "##### 安装MySQL #####"
yum localinstall -y mysql-community-client-$version.rpm mysql-community-client-plugins-$version.rpm mysql-community-common-$version.rpm mysql-community-devel-$version.rpm mysql-community-icu-data-files-$version.rpm mysql-community-libs-$version.rpm mysql-community-server-$version.rpm >/dev/null 2>&1
if [ $? -ne 0 ]
then
echo -e "\033[31m install 'mysql' failed\033[0m"
exit 2
fi
echo "ok!!!!"
3、MySQL初始化配置
# 启动MySQL
systemctl start mysqld
systemctl enable mysqld
# # 查看初始密码 (MySQL 会在首次启动时生成一个临时的 root 用户密码,并将其记录在日志文件中)
grep 'temporary password' /var/log/mysqld.log
# MySQL 安全初始化
# 1、按照提示设置 root 用户的新密码。(包含大小写字母、数字、符号)
# 2、根据提示回答关于移除匿名用户、禁止远程 root 登录、删除测试数据库等的问题。
mysql_secure_installation
# 测试连接
mysql -u root -p