實戰:自訂指令碼啟動mysql-mysql 5.6.19

根據工作環境,自訂一個mysql啟動指令碼

---1.儲存為/usr/local/mysql/scripts/mysql_env.ini

#set mysql init variables
MYSQL_USER=system #mysql的使用者名稱
MYSQL_PASS='password' #mysql的登入使用者密碼

#check input parameter or no
if [ $# -ne 1 ] ; then #判斷輸入的參數個數
echo "mysql port is 3306"
MYSQL_PORT=3306
else
MYSQL_PORT=$1 #$1是傳入的第1個位置參數
echo "mysql port is $1"

fi

---2.啟動mysql

#!/bin/sh
#ocpyang@126.com

MY_CNF=/usr/local/mysql/my.cnf #mysql的設定檔

MYSQLD_SAFE=/usr/local/mysql/bin/mysqld_safe

source /usr/local/mysql/scripts/mysql_env.ini

ERRORLOG=`grep -i "^log-error" $MY_CNF |cut -d = -f 2`

INIT_NUM=1

PORTNUM=`netstat -lnt|grep ${MYSQL_PORT}|wc -l`

 

if [ ! -x $MYSQLD_SAFE ]; then
  echo "mysql安裝時開機檔案未安裝到$MYSQLD_SAFE或無執行許可權"
  exit 1  #0是執行成功,1是執行不成功
else  
 if [ $PORTNUM = 1  ]; then
 echo  "A mysqld process already exists,please stop mysql at first! "
 exit 0
 else
  echo "啟動本機mysql連接埠為:$MYSQL_PORT的服務"
  $MYSQLD_SAFE --defaults-file=$MY_CNF  > /dev/null &
  while  [ $INIT_NUM  -le 5 ]
  do
  PORTNUM=`netstat -lnt|grep ${MYSQL_PORT}|wc -l`
  echo "mysql啟動中....請稍等..."
  sleep 5
   if [ $PORTNUM = 1  ];
   then
    echo "mysql                                      ****啟動成功****"
   exit 0
   fi
 
  INIT_NUM=$(($INIT_NUM +1))
  done
 fi
   echo -e "mysql啟動失敗,請檢查錯誤記錄檔`echo 'cat ' ${ERRORLOG}`"
 echo "*****************************************"
 exit 0
fi

 

 

 

 

 

---3.加入環境變數即可

echo "export PATH=/usr/local/mysql/scripts:\$PATH">>~/.bash_profile

source ~/.bash_profile