Shell script to restart MySQL server if it is killed or not working

in Categories Monitoring last updated April 15, 2019

A simple Linux and Unix bash shell script that would restart your MySQL or MariDB server if it is killed or not working due to ANY reasons.

# Shell script to restart MySQL server if it is killed or not working 
# due to ANY causes.
# When script detects mysql is not running (it basically sends ping request 
# to MySQL) it try to start using /etc/init.d/mysql script; and it sends an 
# email to user indicating the status.
# This script must be run from Cron Job so that it can monitor mysql server. 
# For more info visit following url:
# --------------------------------------------------------------------------
# Copyright (C) 2005 nixCraft project <>
# This script is licensed under GNU GPL version 2.0 or above
# -------------------------------------------------------------------------
# This script is part of nixCraft shell script collection (NSSC)
# Visit for more information.
# -------------------------------------------------------------------------
# mysql root/admin username
# mysql admin/root password
# mysql server hostname
#Shell script to start MySQL server i.e. path to MySQL daemon start/stop script.
# Debain uses following script, need to setup this according to your UNIX/Linux/BSD OS. 
MSTART="/etc/init.d/mysql start"
# Email ID to send notification
# path to mail program 
MAILCMD="$(which mail)"
# path mysqladmin
MADMIN="$(which mysqladmin)"
#### DO NOT CHANGE anything BELOW ####
# see if MySQL server is alive or not
# 2&1 could be better but i would like to keep it simple and easy to
# understand stuff :)
$MADMIN -h $MHOST -u $MUSER -p${MPASS} ping 2>/dev/null 1>/dev/null
if [ $? -ne 0 ]; then
	echo "" >$MAILMESSAGE
	echo "Error: MySQL Server is not running/responding ping request">>$MAILMESSAGE
	echo "Hostname: $(hostname)" >>$MAILMESSAGE
	echo "Date & Time: $(date)" >>$MAILMESSAGE
	# try to start mysql
	# see if it is started or not
	o=$(ps cax | grep -c ' mysqld$')
	if [ $o -eq 1 ]; then
		sMess="MySQL Server MySQL server successfully restarted"
		sMess="MySQL server FAILED to restart"
	# Email status too 
	echo "Current Status: $sMess" >>$MAILMESSAGE
	echo "" >>$MAILMESSAGE
	echo "*** This email generated by $(basename $0) shell script ***" >>$MAILMESSAGE
	echo "*** Please don't reply this email, this is just notification email ***" >>$MAILMESSAGE
	# send email
else # MySQL is running :) and do nothing
# remove file

Share this on:

Start the discussion at Linux/Unix forum

Historical Comment Archive

7 comment

  1. #!/bin/bash
    sub_mysql=’mysql proses down and up’
    MYSQL_START=’/etc/init.d/mysql start’
    #check pid
    if [ $? -ne 0 ]; then
    $MYSQL_START | mail -s “$sub_mysql” $email

  2. Would work better if it check that it could accept commands.

    Something Like….

    mysql -Dmysql -e “SELECT 1;”


  3. Hello

    Thanks for this nice script.
    I’m quite new at server administration, and have 2 questions about your script :
    1- What do you mean by :
    # path to mail program
    MAILCMD=”$(which mail)”
    # path mysqladmin
    MADMIN=”$(which mysqladmin)”

    Do I need to enter the path of both mail and mysql servers ?

    2- If I enter wrong information for the password (and I leave the default intel as question 1), it works …
    So are login and pawd required ?
    Do it works only I 1- is correctly filled ?

    (I’m working with a ovh release 2 (gentoo))


    Have a question? Post it on our forum!