centos 7 shellスクリプトワンタッチmysqlインストール

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 :
$mysql_rpm_package
"  
    else    
    echo -e "you don't have the mysql rpm pakage,now we start download
------------------------"  
    wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm  
    echo -e "complete download mysql rpm
"  
    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
-------------------------"  
    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
-----------------------"  
    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
"  

#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
"  

# 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:
$INITIAL_PASSWORD"  
    echo -e "login mysql: -----------------"  
    mysql -u$USERNAME -p$INITIAL_PASSWORD << EOF  
    create database if not exists myapp;  
    show databases;  
    EOF  
    echo -e "
complete login and create database myapp!"