mysql5.7 on centos7 上使用systemctl管理多个端口 及 创建多个端口的脚本

mysql5.7 on centos7 上使用systemctl管理多个端口 及 创建多个端口的脚本

#!/bin/bash
#Usage: bash install_different_port_for_mysql5.7.sh 9999
#
source /etc/profile
let portn=$1
if [ x"${portn}" == "x" ]; then
   echo "Usage: ./install_different_port_for_mysql5.7.sh portnum"
   exit 1
fi

##检查目标端口是否有已经占用 ps -ef|grep mysql|grep 9999  or netstat -anltp|grep 9999 or lsof -i :9999
lsof -i :${portn}
if [ $? -eq 0 ]; then
   echo "Port ${portn} has been used,please change a port : lsof -i :${portn}"
   exit 1
fi

if [ -d /mysql${portn} ]; then
   echo "Port ${portn} has been used,please change a port : /mysql${portn} has been exis"
   exit 1
fi

cat /etc/my.cnf | grep "${portn}"
if [ $? -eq 0 ]; then
   echo "Port ${portn} has been used,please change a port : port ${portn} has been used in /etc/my.cnf"
   exit 1
fi

##创建目录
mkdir -p /mysql${portn}/{mycnf,socket,pid,data,log}
chown -R mysql.mysql /mysql${portn}/*

##备份my.cnf文件
cp /etc/my.cnf /etc/my.cnf_oldbak

##修改my.cnf文件
cat >> /etc/my.cnf <<EOF

##for mysql port  ${portn}
[mysqld@${portn}]
datadir=/mysql${portn}/data
socket=/mysql${portn}/socket/mysql${portn}.sock
port = ${portn}
log-error=/mysql${portn}/log/error${portn}.log
pid-file=/mysql${portn}pid/mysqld${portn}.pid

EOF

##初始化新的端口
mysqld --initialize --user=mysql --datadir=/mysql${portn}/data



##touch日志文件
touch /mysql${portn}/log/slow${portn}.log
touch /mysql${portn}/log/error${portn}.log
chown -R mysql.mysql /mysql${portn}/log/*.log

##启动端口
systemctl start mysqld@${portn}

##获得新初始化端口root的临时密码
passwdtemp=`cat /var/log/mysqld.log|grep "temporary password"|tail -n1|awk '{print $NF}'`

##修改root的密码
pssroot="Root#2000"
mysql -uroot -p$passwdtemp -S /mysql${portn}/socket/mysql${portn}.sock --connect-expired-password -e "Set password=password('${pssroot}');Alter user 'root'@'localhost' password expire never;CREATE USER 'root'@'%' IDENTIFIED BY '${pssroot}'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION; Flush privileges;create database test_demo;exit"

ls -lrth /mysql${portn}/data/

##检查systemctl的状态 并且设置为enable
systemctl status mysqld@${portn}