1. #!/bin/sh
    2. port=3306  
    3. cmdPath="/usr/local/mysql/bin"
    4. myPath="/storage/mysql/$port"
    5. softPath="/usr/local/mysql"
    6. socketfile="/tmp/mysql$port.sock"
    7. my_user="root"
    8. my_pass="123456"
    10. start(){
    11.         if [ ! -e "$socketfile" ];then
    12.                 printf "Mysqldstarting......\n"
    13.                 $cmdPath/mysqld --defaults-file=/etc/my$port.cnf --user=mysql  &>/dev/null &
    14.                 sleep 2
    15.        else
    16.                 printf "Mysqld alreadyrunning\n" && exit 1
    17.        fi
    18. }
    21. stop(){
    22.        if [ -e "$socketfile" ];then
    23.                 printf "Mysqldstoping......\n"
    24.                 $cmdPath/mysqladmin -u"$my_user" -p"$my_pass" \
    25. -S "$socketfile" shutdown &>/dev/null
    26.                 [ $? -ne 0 ] && echo"error username or password!!!" && exit 1
    27.                 sleep 3
    28.        else
    29.                 printf "Mysqld alreadyclosed\n" && exit 1
    30.        fi
    31. }
    34. restart(){
    35.        stop
    36.         start
    37. }
    39. case "$1" in
    40.        start)
    41.                 start
    42.        ;;
    43.        stop)
    44.                 stop
    45.        ;;
    46.        restart)
    47.                 restart
    48.        ;;
    49.        status)
    50.                 status mysqld
    51.        ;;
    52.        *)
    53.                 echo "Usage: $0{start|stop|restart|status}"
    54.                 exit 1
    55. esac