centos7 shell 脚本一键安装mysql

最新推荐文章于 2024-07-30 21:09:50 发布

NewGirlFriend

最新推荐文章于 2024-07-30 21:09:50 发布

阅读量3.4k

点赞数 1

分类专栏：学习文章标签： centos shell mysql

本文链接：https://blog.csdn.net/NewGirlFriend/article/details/79542107

版权

学习专栏收录该内容

7 篇文章 0 订阅

订阅专栏

使用shell脚本在CentOS上一键下载、安装、登录mysql，自动创建myapp数据库

#1. check if download the mysql rpm package,if not,download

    ql_rpm_package=`find / -name "mysql*release*rpm*"`  
    mysql_rpm_package_name=mysql*release*rpm*  
    if [ `find / -name "mysql*release*rpm*"|wc -l` -ne 0 ];then  
    echo -e "yes,you have the mysql rpm package,it's in :\n$mysql_rpm_package\n"  
    else    
    echo -e "you don't have the mysql rpm pakage,now we start download\n------------------------"  
    wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm  
    echo -e "complete download mysql rpm\n"  
    fi  

#2. check if install local mysql rpm ,if not,install

    if [ `rpm -qa|grep mysql_rpm_package_name|wc -l` -ge 1 ];then  
    echo -e "yes,you have installed local mysql rpm:"  
    rpm -qa | grep mysql_rpm_package_name  
    echo  
    else  
    echo -e "begin install rpm kagage\n-------------------------"  
    yum localinstall mysql57-community-release-el7-11.noarch.rpm  
    echo -e "complete install mysql rpm package,these are mysql in yum repository list:"  
    yum repolist enabled|grep mysql  
    echo  
    fi  

# 3.check if install mysql,if not,install

    if [ `rpm -qa|grep mysql|wc -l` -gt 1 ];then  
    echo -e "yes,you have installed mysql:"  
    rpm -qa |grep mysql  
    echo  
    else  
    echo -e "you don't install mysql,now we start install mysql\n-----------------------"  
    yum install mysql-community-server  
    echo -e "complete install mysql,these are the all installed:"  
    rpm -qa|grep mysql  
    echo  
    fi  

#4. start mysql
    echo -e "start mysql"  
    systemctl start mysqld  
    echo -e "mysql has started\n"  

#5. set mysql start when we start the CentOS

    echo -e "set mysql start when we start the CentOS"  
    systemctl enable mysqld  
    systemctl daemon-reload  
    echo -e "set succeed\n"  

# 6.login mysql use root and initial password

    USERNAME=root  
    INITIAL_PASSWORD=$(awk '/temporary password/{print $NF}' /var/log/mysqld.log)  
    echo -e "your initial mysql password for root is:\n$INITIAL_PASSWORD"  
    echo -e "login mysql: -----------------"  
    mysql -u$USERNAME -p$INITIAL_PASSWORD << EOF  
    create database if not exists myapp;  
    show databases;  
    EOF  
    echo -e "\ncomplete login and create database myapp!"