MySQL Startup program

1.mysqld: MySQL Server

[[email protected] bin]#./mysqld--user=mysql &[[email protected] bin]# ps-ef|grep mysql |grep-v grep mysql    111 11100  2 01:06 pts/1    00:00:00./mysqld--user=mysql

MYSQLD has many parameter options, you can use the following command to view all the list of options:

shell> mysqld--verbose--help

2.mysqld_safe: mysqld startup script
It is recommended to use Mysqld_safe boot Mysql,mysqld_safe to add some security features, such as restarting MySQL server when an error occurs, logging the run-time log to the error log file.
Mysqld_safe reads the configuration information from the [mysqld], [Server], [Mysqld_safe] sections in MY.CNF. In addition, the configuration information for the [SAFE_MYSQLD] section is read for backwards compatibility, but should be written in the current version [Mysqld_safe].

[[email protected] bin]#./mysqld_safe--user=mysql &[1] 11482[[email protected] bin]# 151217 01:16:00 Mysqld_safe Logging to '/var/mysql/data/dbtest.err '. 151217 01:16:00 Mysqld_safe starting mysqld daemon with databases fro M/var/mysql/data[[email protected] bin]# ps-ef|grep mysql|grep-v greproot 11482 11100 0 01:15 pts/1 00:00: 00/bin/sh./mysqld_safe--user=mysqlmysql 11632 11482 3 01:15 pts/1 00:00:00/usr/local/mysql/bin/mysqld--basedir =/usr/local/mysql--datadir=/var/mysql/data--plugin-dir=/usr/local/mysql/lib/plugin--user=mysql--log-error=/var After/mysql/data/dbtest.err--pid-file=/var/mysql/data/dbtest.pid# starts MySQL server with Mysqld_safe, it automatically restarts after mysqld the exception terminal [[                  Email protected] bin]# kill-9 11632[[email protected] bin]#./mysqld_safe:line 166:11632 Killed Nohup/usr/local/mysql/bin/mysqld--basedir=/usr/local/mysql--datadir=/var/mysql/data--plugin-dir=/usr/local/ Mysql/lib/plugin--user=mysql--log-error=/var/mysql/data/dbtest.err--pid-file=/var/mysql/data/dbtest.pid </dev/null >>/var/mysql/data/dbtest.err 2>& 1151217 01:16:17 mysqld_safe Number of processes running now:0151217 01:16:17 mysqld_safe mysqld RESTARTED[[EMAIL&NBSP;PR Otected] bin]# ps-ef|grep mysql|grep-v greproot 11482 11100 0 01:15 pts/1 00:00:00/bin/sh./mysqld_safe--user= Mysqlmysql 11673 11482 5 01:16 pts/1 00:00:00/usr/local/mysql/bin/mysqld--basedir=/usr/local/mysql--datadir=/var /mysql/data--plugin-dir=/usr/local/mysql/lib/plugin--user=mysql--log-error=/var/mysql/data/dbtest.err-- Pid-file=/var/mysql/data/dbtest.pid

3.mysql.server: mysqld startup script
Mysql.server also starts MySQL server by calling the Mysqld_safe script.

[Email protected] bin]#/mysql.server startstarting mysql[  OK  ][[email protected] bin]# ps-ef|grep Mysql|grep -V greproot     11783     1  0 01:23 pts/1    00:00:00/bin/sh/usr/local/mysql/bin/mysqld_safe--datadir=/var/ Mysql/data--pid-file=/var/mysql/data/dbtest.pidmysql    11948 11783  2 01:23 pts/1    00:00:00/usr/local/ Mysql/bin/mysqld--basedir=/usr/local/mysql--datadir=/var/mysql/data--plugin-dir=/usr/local/mysql/lib/plugin-- User=mysql--log-error=/var/mysql/data/dbtest.err--pid-file=/var/mysql/data/dbtest.pid

4.mysqld_multi: managing multiple MySQL Servers

MySQL Startup program