Purchase Linux CDs / DVDs / Flash Drives at OSDisc.com

Welcome to Our Community

While Linux.org has been around for a while, we recently changed management and had to purge most of the content (including users). If you signed up before April 23rd please sign up again. Thanks!

script for to stop mysql process

Discussion in 'Database' started by raghu88, Mar 21, 2013.

  1. raghu88

    raghu88 Guest

    Hi to all,

    Any one help me out,

    i want a script to stop mysql process(without using kill command).

    Help me out.



    Thanks in advance.
     
  2. laurentv

    laurentv Guest

    to stop mysql
    service mysqld stop
     
    1 person likes this.
  3. Rob

    Rob Guest

    Yup.. either that or
    /etc/init.d/mysql stop
     
  4. akbarali

    akbarali Guest

    Hello raghu88

    To automatically start or stop mysql you can use the following link which has provided all the necessary details and command of how to do it.

    Thanks...Go to below link.

    dev.mysql.com/doc/refman/5.1/en/automatic-start.html
     
  5. taiavatar

    taiavatar Guest

    you can use /etc/init.d/mysqld stop
     
  6. Copy the code below highlighted in blue , save it in a file and execute for output. There are 2 variables mysqld_file and mysqld_safe_file where the path of mysqld and mysqld_safe executables have to be configured based on your installation.

    ################################################################################
    # Configure MySQL commands mysqld and mysqld_safe path here.
    # Ex. mysqld_file="/usr/sbin/mysqld"
    # mysqld_safe_file="/usr/bin/mysqld_safe"
    ####################################################################################
    mysqld_file="/usr/sbin/mysqld"
    mysqld_safe_file="/usr/bin/mysqld_safe"
    #################################################################################
    echo -e "\n`date` : $0 is being executed.\n"
    ls -ltrh $mysqld_file >> /dev/null;
    if [ $? -eq 1 ]
    then
    echo -e "`date` : $mysqld_file not present.Please verify your MySQL installation"
    echo " "
    exit
    fi
    if [ `whoami` != 'root' ]
    then
    echo -e "`date` : You have to be a root user to start MySQL."
    echo " "
    exit
    fi
    pid=`ps -ef|grep "$mysqld_file" |grep -v 'grep' |awk '{print $2}'`
    if [ -z $pid ]
    then
    echo -e "`date` : MySQL database process is not running."
    echo " "
    exit
    else
    echo -e "`date` : MySQL process is running. PID - $pid - Stopping now. Please wait. It may take few minutes"
    fi
    kill $pid
    if [ $? -eq 0 ]
    then Status="Success"
    else Status="Failure"
    fi
    sleep 2
    echo -e "------------------------------------------------------------------"
    echo -e "`date` : MySQL Shutdown is : $Status"
    echo -e "------------------------------------------------------------------"
    echo " "
    #################################################################################

    Regards
    -----
    LinuxFreakz
     
  7. how about :
    # sudo su
    # service mysql stop
    -- I use Centos 7
     
  8. Crippled

    Crippled Guest

    If I had to do all this to stop something running on my computer I would smash it with a sledgehammer.
     

Share This Page