一鍵安裝mysql

標籤：else   char   nodeps   shel   one   ram   mct   x86   一鍵   

#!/bin/bash# # Rrogram:# install mysql# History:#    2017-10-05    luoqi    v0.1 release# email:#    916790942@qq.com    #以下rpm包需要自己下載並和該指令碼放在同一目錄下#mysql-community-server-5.7.19-1.el7.x86_64.rpm mysql-community-client-5.7.19-1.el7.x86_64.rpm mysql-community-common-5.7.19-1.el7.x86_64.rpm #mysql-community-libs-5.7.19-1.el7.x86_64.rpm## dependenceyum -y  install perlyum -y  install -y perl-Module-Install.noarch yum -y  install net-tools#created by Kevin 2016/03/30, modify 2016/04/20# -----------------------------------------------------------------------------# Installation Script for the auto-deployment EMM(Linux edition)# -----------------------------------------------------------------------------# -----------------------------------------------------------------------------# shell script to install MySQL (default version mysql-community-5.7.19)echo "-----------------------start install mysql----------------------"# Add to mysql user and mysql groupif [ `grep "mysql" /etc/passwd | wc -l` -eq 0 ];thenecho "adding user mysql"groupadd mysqluseradd -r -g mysql mysqlelseecho "mysql user is exist"fi# check installed mysql or notfor i in `rpm -qa | grep "mysql"`do rpm -e --allmatches $i --nodepsdone# Remove pre-installed on OS MariaDB if existsfor i in $(rpm -qa | grep mariadb | grep -v grep)do  echo "Deleting rpm --> "$i  rpm -e --nodeps $idone# Install mysqlserverrpm -ivh mysql-community-server-5.7.19-1.el7.x86_64.rpm mysql-community-client-5.7.19-1.el7.x86_64.rpm mysql-community-common-5.7.19-1.el7.x86_64.rpm mysql-community-libs-5.7.19-1.el7.x86_64.rpm# check the installtation was successful or not rpm -qa |grep "mysql"if [ $? != 0 ];thenecho "mysql install fail"| tee $mysql_instlogexit 1else echo "mysql isntall success"| tee $mysql_instlogfi# modify configuration files  cd /etc/echo "character_set_server=utf8" >> my.cnf# startup the mysqlsystemctl start mysqld systemctl status mysqld/etc/init.d/mysqld start /etc/init.d/mysqld stopecho "MySQL Server install successfully!"# configurationcat /etc/my.cnfsed -i ‘/mysqld/a\skip-grant-tables‘ /etc/my.cnfsystemctl restart mysqld# mysql -u root mysqlmysql -u root mysql -e "use mysql;"# use mysql# update mysql.user set authentication_string=password(‘root‘) where user=‘root‘ ;mysql -u root mysql -e "update mysql.user set authentication_string=password(‘root‘) where user=‘root‘ ;"mysql -u root mysql -e "flush privileges;"cat /etc/my.cnfsed -i ‘/skip-grant-tables/s/^/#/‘ /etc/my.cnf# mysql -u root -p# SET PASSWORD = PASSWORD(‘root‘);mysql -u root -proot --connect-expired-password -e "SET PASSWORD = PASSWORD(‘root‘);"echo "install successfully!!"# exit

https://dev.mysql.com/downloads/mysql/ 下載mysql

一鍵安裝mysql