Shell脚本安装mysql-8.0.12（二进制包安装）

最新推荐文章于 2025-10-28 13:59:27 发布

原创最新推荐文章于 2025-10-28 13:59:27 发布 · 1.2k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#脚本 #mysql #centos7 #二进制 #shell

shell 专栏收录该内容

15 篇文章

订阅专栏

本文提供了一套完整的Shell脚本，用于在CentOS Linux release 7.3.1611 (Core)系统上一键安装MySQL 8.0.12版本。脚本详细步骤包括安装依赖包、配置环境变量、初始化数据库、设置启动文件等，最后还介绍了如何修改MySQL登录密码。

Shell脚本安装mysql-8.0.12（二进制包安装）

[root@localhost ~]# cat  /etc/redhat-release 
CentOS Linux release 7.3.1611 (Core)

#!/bin/bash
#与后面endtime结合现实脚本安装时间
start_time=$(date +%s)

#安装mysql依赖包
yum -y install gcc gcc-c++ openssl openssl-devel libaio libaio-devel  ncurses  ncurses-devel  >> /dev/null

#mysql官网下载64位的二进制版本:mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz ，置于/root目录下
tar  xvfJ  /root/mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz  -C  /usr/local/
mv  /usr/local/mysql-8.0.12-linux-glibc2.12-x86_64  /usr/local/mysql8


# 创建数据库文件目录和创建日志目录
mkdir  /usr/local/mysql8/{data,log}


#创建mysql组和用户
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
chown  -R  mysql:mysql /usr/local/mysql8


#配置/etc/my.cnf
cat > /etc/my.cnf <<EOF
[mysqld]
port=3306
datadir=/usr/local/mysql8/data
log-error=/usr/local/mysql8/log/mysql-err.log
user=mysql
[client]
socket=/tmp/mysql.sock
EOF


#配置环境变量
echo "export PATH=$PATH:/usr/local/mysql8/bin"  >>  /etc/profile
source /etc/profile


#初始化数据库
/usr/local/mysql8/bin/mysqld  --initialize  --user=mysql  --basedir=/usr/local/mysql8　--datadir=/usr/local/mysql8/data   >>  /dev/null


#制作启动文件
cp  /usr/local/mysql8/support-files/mysql.server  /etc/init.d/mysqld
sed  -i  's/^basedir=/basedir=\/usr\/local\/mysql8/'  /etc/init.d/mysqld
sed  -i  's/^datadir=/datadir=\/usr\/local\/mysql8\/data/'  /etc/init.d/mysqld
chmod  755 /etc/init.d/mysqld


#启动mysql服务
/etc/init.d/mysqld start


#关闭mysql服务　
#/etc/init.d/mysqld stop
echo "#####mysql8安装完成#####"


#修改mysql登录密码
b=`grep  'temporary password'   /usr/local/mysql8/log/mysql-err.log`
a=`echo ${b##*localhost:}`
echo $a

#创建/usr/local/mysql8/bin/mysql软连接，便于命令行直接执行mysql
ln  -s  /usr/local/mysql8/bin/mysql   /usr/bin/mysql

#mysql -e　可以直接在命令行执行命令,123456是设定的新密码
mysql -uroot -p"${a}" -e  "ALTER USER 'root'@'localhost'  IDENTIFIED  BY '123456'"  --connect-expired-password
echo  "#####mysql8密码修改成功#####"



end_time=$(date +%s)
cost_time=$((end_time - start_time))
echo $cost_time