mysql 启动脚本

[root@gby /usr/local/bin]# cat /usr/local/mysql/bin/mysqlctl
#!/bin/sh
#Mysql start|stop|restart

mysql_port=$2
mysql_username="用户名"
mysql_password="密码"
mysql_port="3306"
function_start_mysql()
{
   printf "Starting MySQL....../n"
   /usr/local/mysql/bin/mysqld_safe 2>&1 > /dev/null &
}
function_stop_mysql()
{
   printf "Stoping MySQL....../n"
   /usr/local/mysql/bin/mysqladmin -u${mysql_username} -p${mysql_password} -S /tmp/mysql.sock shutdown

   #/usr/local/mysql/bin/mysqld_safe --user=mysql --basedir=/usr/local/mysql &
}
function_restart_mysql()
{
   printf "Restarting MySQL....../n"
   function_stop_mysql
   function_start_mysql
}
function_open_mysql()
{
   /usr/local/mysql/bin/mysql -u${mysql_username} -p${mysql_password}
}
if [ "$1" = "start" ]; then
   function_start_mysql
elif [ "$1" = "stop" ]; then
   function_stop_mysql
elif [ "$1" = "restart" ]; then
   function_restart_mysql
elif [ "$1" = "open" ]; then
   function_open_mysql
else
   printf "Usage: mysql.sh {start|stop|restart}/n"
fi
############################################################
#Usage:chmod +x mysq.sh
#mysql.sh start 3306   mysql.sh stop 3306   mysql.sh restart mysql.sh open