MySQL : mysqld_safe

mysqld_safe is wrapper used to mysql server startup and is recommended way to start a mysqld server on UNIX

• mysqld_safe provides safety feature such as restarting the server when error occurs and write run time information to error log
• mysqld_safe tries to start and executable mysqld to override the default behavior and specify explicitly the name of the server you want to run 
• specify --mysqld or --mysqld --version to mysqld_safe
• mysqld_safe reads all options  from the [mysqld][server] and [mysqld_safe] sections in option files.

options with mysqld_safe

Format	Description
--basedir	Path to mysql installation directory
--core-file-size	Size of core file
--datadir	Data directory path
--defaults-extra-file	Read named option file in addition to usual option files
--default-file	Read only names option file
--help	Help message and exit
--ledir	Path to directory where server is located
--log-error	Write error log to named file
--malloc-lib	Alternative malloc library to use for mysqld
--mysqld	Name of server program to start
--mysqld-safe—log-timestamp	Timestamp format logging
--mysqld-version	Suffix for server program name
--nice	Use nice program to set server scheduling priority
--no-defaults	Read no options file
--open-files-limit	Number of files that mysqld should be able to open
--pid-file	Path named server process ID file
--port	Port number
--skip-kill-mysqld	Do not try kill stray mysqld processes
--skip-syslog	Do not write error message to syslog, use log error
--socket	Socket file
--syslog	Write error message to syslog
--syslog-tag	Tag suffix for message written to syslog
--timezone	Set timezone
--user	Run mysqld as user having name user_name or numeric used ID user_id