shell脚本安装mysql 8.0

最新推荐文章于 2024-10-09 18:19:09 发布

云原生IT民工

最新推荐文章于 2024-10-09 18:19:09 发布

阅读量197

点赞数 2

分类专栏： database 文章标签： mysql adb android

本文链接：https://blog.csdn.net/u010948569/article/details/142774622

版权

database 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

#!/bin/bash

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

#mysql官网下载64位的二进制版本:mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz ，置于/root目录下
tar  xvfJ  /root/mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz  -C  /usr/local/
mv  /usr/local/mysql-8.0.26-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
ln  -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5

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