mysqld_safe --user=mysql

#!/bin/sh
#
# MySQL        MySQL 4.x daemon startup script.
#
# This script was developed and tested on Fedora Core 3 with MySQL 4.0.
# Use at your OWN risk and RESPONSABILITY!
# No warranty supplied nor implied.
# This script was adapted from the NetworkManager script - if anyone cares.
#
# chkconfig: - 84
# description:  The MySQL 4.x Database server.
#
# processname: MySQL
# pidfile: /var/run/NetworkManager.pid
#

# the MySQL bin path (is by default pointing at the default MySQL bin path.
# for your distribution, you might wanna change this!)
binpath=/usr/local/mysql/bin

# Make shure this is at all possible
[ -x $binpath/mysql_safe ] || exit 1

# In order to stop again, we'll mysqladmin since kill signals are trapped
[ -x $binpath/mysqladmin ] || exit 1

# Source function library.
. /etc/rc.d/init.d/functions

# so we can rearrange this easily
servicename=mysqld_safe --user=mysql

# we need a MySQL user with SHUTDOWN privileges
user=root
# and his password
password= 

RETVAL=0

start()
{
	echo -n $"Starting MySQL server: "
	daemon $servicename
	RETVAL=$?
	# I don't think that this is really need, but who knows?
	# commented out anyways.
	#[ $RETVAL -eq 0 ] && touch /var/lock/subsys/$servicename 
	echo
	return $RETVAL
}

stop()
{
	echo -n $"Stopping MySQL server: "
	# killproc $servicename -TERM # kills are trapped so we have to use mysqladmin
	# mysqladmin handles all that .pid stuff so we have our hands free
	$binpath/mysqladmin shutdown --user=$user --password=$password
	RETVAL=$?
	echo
	return $RETVAL
}

# See how we were called.
case "$1" in
	start)
		start
		;;
	stop)
		stop
		;;
	status)
		status $processname
		RETVAL=$?
		;;
	restart)
		stop
		start
		;;
#	condrestart)
#		if [ -f /var/lock/subsys/$servicename ]; then
#			stop
#			start
#		fi
#		;;
	*)
		echo $"Usage: $0 {start|stop|status|restart}" #|condrestart}"
		;;
esac
exit $RETVAL

#include <stdlib.h>
#include <unistd.h>

int main(int argc, char *argv[])
{
	int status;
	pid_t pid;
	
	pid = fork ();
	if (pid == 0)
	{
		status = system("mysqld_safe --user=mysql");
	}
	else if (pid < 0)
		status = -1;
	return status;
}