centos7安装部署mysql57脚本

聂子轩、

已于 2023-10-30 19:22:16 修改

阅读量121

点赞数

分类专栏： # MYSQL # Linux脚本文章标签： adb

于 2023-10-30 19:20:53 首次发布

本文链接：https://blog.youkuaiyun.com/m0_62755217/article/details/134119736

版权

MYSQL 同时被 2 个专栏收录

10 篇文章

订阅专栏

Linux脚本

2 篇文章

订阅专栏

本文介绍了一个Bash脚本，用于自动化安装MySQL5.7，设置root用户的密码，开启3306端口的远程访问，并禁用防火墙。脚本首先检查wget和mysql是否已安装，然后进行安装并设置临时密码，最后修改密码并允许远程登录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

端口号：3306

账号：root

密码：Mysql@2023

对外所有ip开放，且开放所有数据库

脚本如下：

# !/bin/bash

#安装wget
if type -p  wget; then
    echo "wget has been installed."
else
    yum install wget  -y
fi
 
if type -p mysql; then
    echo "mysql has been installed."
else
    #开始安装mysql
    echo "Download msyql5.7 rpm..."
 
    wget  http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
 
    echo "Start to install mysql5.7..."
    sudo yum -y install mysql57-community-release-el7-10.noarch.rpm
    rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
    sudo yum -y install mysql-community-server  

    echo "启动mysql 服务"
    sudo systemctl start mysqld.service
 
    SQL_VERSION=`mysql -V | grep -i -o -P '5.7'`
    if [ $SQL_VERSION == "5.7" ];then
        echo "check msyql install ok!"
    else
        echo -e "\033[31m Msyql install error, Please install it manually \033[0m" 
        exit 0
    fi
 
    echo "msyql 临时密码:"
    grep 'password' /var/log/mysqld.log |head -n 1 |grep -oE "localhost:(.+)$" | grep -i -o -P 'localhost: \K.+'
 
    echo "try modify database use password"
    # get mysql temp password
    TEMP_PWD=`grep 'password' /var/log/mysqld.log |head -n 1 |grep -oE "localhost:(.+)$" | grep -i -o -P 'localhost: \K.+'`
    echo $TEMP_PWD
 
    # get mysql sock file 
    SOCK=`netstat -ln | grep mysql | head -n 2 | awk '{print $9}'`
    PORT="3306"
    USER="root"
    # modify set your ownpwd    
    PASSWORD="Mysql@2023"
    WRAPPWD="\"Mysql@2023\""
 
    # modify password
    mysql --connect-expired-password -p$TEMP_PWD -S $SOCK -e 'alter user user() identified by '$WRAPPWD
 
    echo "modify database password ok!"
    echo "new password: $PASSWORD"
    #mysql开启远程访问
    mysql  -uroot -p'Mysql@2023' -e"grant all privileges on *.* to 'root'@'%' identified by 'Mysql@2023';"
    mysql  -uroot -p'Mysql@2023' -e"flush privileges;"
    echo "开启远程访问"
    #关闭防火墙
    systemctl stop firewalld.service
    systemctl disable firewalld.service
fi