Shell脚本操作MySQL服务

1、编写Shell脚本

#! /bin/sh
case $1 in
    start)
        /usr/local/mysql/bin/mysqld_safe --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql &
        echo "MySQL service has stated."
        ;;
    stop)
        killall mysqld;
        echo "MySQL service has stoped."
        ;;
    restart)
        killall mysqld
        /usr/local/mysql/bin/mysqld_safe --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql &
        echo "MySQL service has restarted."
        ;;
    *)
        echo "No such argument."
        exit 1
        ;;
esac

2、创建软链接，将脚本作为服务运行

shell> sudo ln -s ~/workspace/shell/mysql/mysqld /etc/init.d/mysqld

3、启动、停止、重启MySQL服务

shell> sudo service mysqld start
shell> sudo service mysqld stop
shell> sudo service mysqld restart