#!/bin/bashMQL_PACKAGE=/home/kingstar/program/software/rpm包名MYSQL_Unpack=/home/kingstar/program/software/mysql_tarMYSQL_ROOT_PASSWORD=Aa123#2.follow documentif [ `rpm -qa|grep mysql|wc -l` -ne 0 ];then echo -e "yes,you have installed mysql:" rpm -e --nodeps `rpm -qa | grep mysql` fi #rpm -qa | grep -i mariadbif [ `rpm -qa|grep -i mariadb|wc -l` -ne 0 ];then echo -e "yes,you have installed mariadb we are uninstalling:" rpm -e --nodeps `rpm -qa | grep mariadb` fi #1. check if download the mysql rpm package,if not,download# mql_rpm_package=`find / -name "mysql*rpm-bundle.tar"` # mysql_rpm_package_name=mysql*rpm-bundle.tar# mysql_d=`find / -name "07mysql" -type d`# if [ `find /*/package/02base/07mysql -name "mysql*rpm-bundle.tar"|wc -l` -ne 0 ];then # echo -e "yes,you have the mysql bundle package,it‘s in :$mql_rpm_package" tar xvf $MQL_PACKAGE -C $MYSQL_Unpack# else # echo -e "you don‘t have the mysql rpm pakage,but 有离线bundle包就够了\n------------------------" # wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm #echo -e "complete download mysql rpm\n" # fi#Inspection groupif [ `cat /etc/group|grep mysql| wc -l` -eq 1 ];then echo -e "Group created:" else groupadd mysql fi #Check mysql usersif [ `cat /etc/passwd|grep mysql|wc -l` -eq 1 ];then echo -e "User created:" else useradd -r -g mysql mysql fi#Go to folder cd $MYSQL_Unpack echo -e "I came in"#Install the RPM#sudo rpm -ivh libaio-*.rpmsudo rpm -ivh mysql-community-common-5*.rpmsudo rpm -ivh mysql-community-libs-5*.rpmsudo rpm -ivh mysql-community-client-5*.rpmsudo rpm -ivh mysql-community-server-5*.rpmecho "The installation is complete"sudo chown mysql:mysql /var/lib/mysql -Rsudo chmod 777 /var/logsudo chown mysql:mysql /var/log/mysqld.log -Rmkdir -p /opt/datamysqld –initialize --user=mysql --datadir=/opt/data#No password#sed -i "s/datadir=\/var\/lib\/mysql/datadir=$mql_rpm_package/g" /etc/my.cnf#sed -i "s/# /skip-name-resolve/g" /etc/my.cnfsed -i "s/# log_bin/skip-grant-tables/g" /etc/my.cnfservice mysqld restartsudo chmod 777 /varmysql -uroot <<EOFupdate mysql.user set authentication_string=password(‘$MYSQL_ROOT_PASSWORD‘) where user=‘root‘;flush privileges;EOF#Turn off the firewallsystemctl stop firewalld.service#Remove passwords and allow remote connectionssed -i "s/skip-grant-tables/skip-name-resolve/g" /etc/my.cnfecho "Jump out and execute"service mysqld restartecho "Mysql is rebooting"#Ignore the warningmysql -hlocalhost -P3306 -uroot -pkingstar --connect-expired-password -A -N <<EOFset global validate_password_policy=0;set global validate_password_length=1;ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘$MYSQL_ROOT_PASSWORD‘;GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘$MYSQL_ROOT_PASSWORD‘ WITH GRANT OPTION;flush privileges;EOFservice mysqld restartecho "Configuration is successful"rm *.rpmecho "The RPM package was deleted successfully"echo "Start brushing basic data"cat $MYSQL_Unpack/*.sql | mysql -uroot -p$MYSQL_ROOT_PASSWORDecho "Basic data update completed"