索引

当mysql运行设置好密码后就可以使用一下shell脚本，进行管理mysql 创建shell文件： vi /data0/mysql/3306/mysql

shell：

#!/bin/sh mysql_port=3306 #mysql 安装后用户名密码 mysql_username=”admin” mysql_password=”12345678”

function_start_mysql() {

  printf "Starting MySQL...\n"
  #mysql安装目录，以及my.cnf路径 配置文件
  /bin/sh /usr/local/webserver/mysql/bin/mysqld_safe --defaults-file=/data0/mysql/${mysql_port}/my.cnf 2>&1 > /dev/null &   

}

function_stop_mysql() {

  printf "Stoping MySQL...\n"  
  /usr/local/webserver/mysql/bin/mysqladmin -u ${mysql_username} -p${mysql_password} -S /tmp/mysql.sock shutdown   

}

function_restart_mysql() {

  printf "Restarting MySQL...\n"  
  function_stop_mysql   
  sleep 5   
  function_start_mysql   

}

function_kill_mysql() {

  kill -9 $(ps -ef | grep 'bin/mysqld_safe' | grep ${mysql_port} | awk '{printf $2}')   
  kill -9 $(ps -ef | grep 'libexec/mysqld' | grep ${mysql_port} | awk '{printf $2}')   

}

if [ “$1” = “start” ]; then

  function_start_mysql   

elif [ “$1” = “stop” ]; then

  function_stop_mysql   

elif [ “$1” = “restart” ]; then function_restart_mysql elif [ “$1” = “kill” ]; then function_kill_mysql else

  printf "Usage: /data0/mysql/${mysql_port}/mysql {start|stop|restart|kill}\n"  

fi

#shell end

赋予shell脚本可执行权限： [code] chmod +x /data0/mysql/3306/mysql [/code]

启动MySQL： [code] /data0/mysql/3306/mysql start [/code]

停止MySQL： [code] /data0/mysql/3306/mysql stop [/code]

运行shell文件的时候通过后面的变量，start，stop来调用shell里面的方法。

这是通过shell脚本来实现多个命令的封装。

到顶部