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
