MySQL distributions on Unix include a script named mysql.server, which starts the server using mysqld_safe. It can be used on systems such as Linux and Solaris that use System V-style run directories to start and stop system services. It is also used by the OS X Startup Item for MySQL.
mysql.server can be found in the
support-files directory under your MySQL
installation directory or in a MySQL source distribution.
If you use the Linux server RPM package
the mysql.server script will be installed in
/etc/init.d directory with the name
mysql. You need not install it manually.
See Section 2.5.1, “Installing MySQL on Linux Using RPM Packages”, for more
information on the Linux RPM packages.
Some vendors provide RPM packages that install a startup script under a different name such as mysqld.
If you install MySQL from a source distribution or using a binary distribution format that does not install mysql.server automatically, you can install it manually. Instructions are provided in Section 2.10.3, “Starting and Stopping MySQL Automatically”.
mysql.server reads options from the
[mysqld] sections of option files. For
backward compatibility, it also reads
[mysql_server] sections, although you should
rename such sections to
using MySQL 5.5.
mysql.server supports the following options.
|--basedir=path||Path to MySQL installation directory|
|--datadir=path||Path to MySQL data directory|
|--pid-file=file_name||File in which server should write its process ID|
|--service-startup-timeout=seconds||How long to wait for server startup|
|--use-manager||Use Instance Manager to start server||5.5.0|
|--use-mysqld_safe||Use mysqld_safe to start server||5.5.0|
|--user=user_name||Run server using this login user name||5.5.0|
The path to the MySQL installation directory.
The path to the MySQL data directory.
The path name of the file in which the server should write its process ID.
If this option is not given, mysql.server
uses a default value of
The PID file value passed to mysqld_safe
overrides any value specified in the
[mysqld_safe] option file group. Because
mysql.server reads the
[mysqld] option file group but not the
[mysqld_safe] group, you can ensure that
mysqld_safe gets the same value when
invoke using mysql.server as when invoked
manually by putting the same
setting in both the
How long in seconds to wait for confirmation of server startup. If the server does not start within this time, mysql.server exits with an error. The default value is 900. A value of 0 means not to wait at all for startup. Negative values mean to wait forever (no timeout).