Oracle 5.0, Справочное руководство

Страница: 268 / 3232

mysqld_safe
— MySQL Server Startup Script
248
Use the
nice
program to set the server's scheduling priority to the given value.
•
--no-defaults
[248]
Do not read any option files. This must be the first option on the command line if it is used.
•
--open-files-limit=count
[248]
The number of files that
mysqld
should be able to open. The option value is passed to
ulimit -n
.
Note that you need to start
mysqld_safe
as
root
for this to work properly!
•
--pid-file=file_name
[248]
The path name of the process ID file.
•
--port=port_num
[248]
The port number that the server should use when listening for TCP/IP connections. The port number
must be 1024 or higher unless the server is started by the
root
system user.
•
--skip-kill-mysqld
[248]
Do not try to kill stray
mysqld
processes at startup. This option works only on Linux.
•
--socket=path
[248]
The Unix socket file that the server should use when listening for local connections.
•
--timezone=timezone
[248]
Set the
TZ
time zone environment variable to the given option value. Consult your operating system
documentation for legal time zone specification formats.
•
--user={user_name|user_id}
[248]
Run the
mysqld
server as the user having the name
user_name
or the numeric user ID
user_id
.
(“User” in this context refers to a system login account, not a MySQL user listed in the grant tables.)
If you execute
mysqld_safe
with the
--defaults-file
[247] or
--defaults-extra-
file
[247] option to name an option file, the option must be the first one given on the command line
or the option file will not be used. For example, this command will not use the named option file:
mysql> mysqld_safe --port=port_num --defaults-file=file_name
Instead, use the following command:
mysql> mysqld_safe --defaults-file=file_name --port=port_num
The
mysqld_safe
script is written so that it normally can start a server that was installed from either
a source or a binary distribution of MySQL, even though these types of distributions typically install the
server in slightly different locations. (See
Section 2.7, “Installation Layouts” .)
mysqld_safe
expects
one of the following conditions to be true:
• The server and databases can be found relative to the working directory (the directory from which
mysqld_safe
is invoked). For binary distributions,
mysqld_safe
looks under its working directory
for
bin
and
data
directories. For source distributions, it looks for
libexec
and
var
directories. This
condition should be met if you execute
mysqld_safe
from your MySQL installation directory (for
example,
/usr/local/mysql
for a binary distribution).
• If the server and databases cannot be found relative to the working directory,
mysqld_safe
attempts to locate them by absolute path names. Typical locations are
/usr/local/libexec
and
/usr/local/var
. The actual locations are determined from the values configured into the