Gecko [ www.jdcpatala.org ]

Name	Size	Permission
comp_err.1	5.59 KB	-rw-r--r--
innochecksum.1	17.57 KB	-rw-r--r--
lz4_decompress.1	3.12 KB	-rw-r--r--
my_print_defaults.1	6.29 KB	-rw-r--r--
myisam_ftdump.1	5.78 KB	-rw-r--r--
myisamchk.1	49.35 KB	-rw-r--r--
myisamlog.1	5.15 KB	-rw-r--r--
myisampack.1	19.31 KB	-rw-r--r--
mysql.1	88.14 KB	-rw-r--r--
mysql.server.1	10.12 KB	-rw-r--r--
mysql_config.1	7.83 KB	-rw-r--r--
mysql_config_editor.1	22.53 KB	-rw-r--r--
mysql_install_db.1	22.28 KB	-rw-r--r--
mysql_plugin.1	9.02 KB	-rw-r--r--
mysql_secure_installation.1	10.32 KB	-rw-r--r--
mysql_ssl_rsa_setup.1	11.3 KB	-rw-r--r--
mysql_tzinfo_to_sql.1	4.37 KB	-rw-r--r--
mysql_upgrade.1	23.95 KB	-rw-r--r--
mysqladmin.1	29.68 KB	-rw-r--r--
mysqlbinlog.1	70.46 KB	-rw-r--r--
mysqlcheck.1	26.89 KB	-rw-r--r--
mysqld_multi.1	15.65 KB	-rw-r--r--
mysqld_safe.1	22.14 KB	-rw-r--r--
mysqldump.1	67.3 KB	-rw-r--r--
mysqldumpslow.1	6.43 KB	-rw-r--r--
mysqlimport.1	22.49 KB	-rw-r--r--
mysqlman.1	675 B	-rw-r--r--
mysqlpump.1	50.59 KB	-rw-r--r--
mysqlshow.1	19.73 KB	-rw-r--r--
mysqlslap.1	26.38 KB	-rw-r--r--
perror.1	4.75 KB	-rw-r--r--
replace.1	4.62 KB	-rw-r--r--
resolve_stack_dump.1	4.25 KB	-rw-r--r--
resolveip.1	3.54 KB	-rw-r--r--
zlib_decompress.1	3.14 KB	-rw-r--r--

Code Editor : mysql_install_db.1

'\" t
.\"     Title: mysql_install_db
.\"    Author: [FIXME: author] [see http://docbook.sf.net/el/author]
.\" Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/>
.\"      Date: 08/29/2022
.\"    Manual: MySQL Database System
.\"    Source: MySQL 5.7
.\"  Language: English
.\"
.TH "MYSQL_INSTALL_DB" "1" "08/29/2022" "MySQL 5\&.7" "MySQL Database System"
.\" -----------------------------------------------------------------
.\" * Define some portability stuff
.\" -----------------------------------------------------------------
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.\" http://bugs.debian.org/507673
.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\" -----------------------------------------------------------------
.\" * set default formatting
.\" -----------------------------------------------------------------
.\" disable hyphenation
.nh
.\" disable justification (adjust text to left margin only)
.ad l
.\" -----------------------------------------------------------------
.\" * MAIN CONTENT STARTS HERE *
.\" -----------------------------------------------------------------
.SH "NAME"
mysql_install_db \- initialize MySQL data directory
.SH "SYNOPSIS"
.HP \w'\fBmysql_install_db\ [\fR\fB\fIoptions\fR\fR\fB]\fR\ 'u
\fBmysql_install_db [\fR\fB\fIoptions\fR\fR\fB]\fR
.SH "DESCRIPTION"
.if n \{\
.sp
.\}
.RS 4
.it 1 an-trap
.nr an-no-space-flag 1
.nr an-break-flag 1
.br
.ps +1
\fBNote\fR
.ps -1
.br
.PP
\fBmysql_install_db\fR
is deprecated as of MySQL 5\&.7\&.6 because its functionality has been integrated into
\fBmysqld\fR, the MySQL server\&. To initialize a MySQL installation, invoke
\fBmysqld\fR
with the
\fB\-\-initialize\fR
or
\fB\-\-initialize\-insecure\fR
option\&. For more information, see
Section\ \&2.10.1, \(lqInitializing the Data Directory\(rq\&. You should expect
\fBmysql_install_db\fR
to be removed in a future MySQL release\&.
.sp .5v
.RE
.PP
\fBmysql_install_db\fR
handles initialization tasks that must be performed before the MySQL server,
\fBmysqld\fR, is ready to use:
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
It initializes the MySQL data directory and creates the system tables that it contains\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
It initializes the
system tablespace
and related data structures needed to manage
InnoDB
tables\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
It loads the server\-side help tables\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
It installs the
sys
schema\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
It creates an administrative account\&. Older versions of
\fBmysql_install_db\fR
may create anonymous\-user accounts\&.
.RE
Secure\-by\-Default Deployment
.PP
Current versions of
\fBmysql_install_db\fR
produce a MySQL deployment that is secure by default, with these characteristics:
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
A single administrative account named
\*(Aqroot\*(Aq@\*(Aqlocalhost\*(Aq
is created with a randomly generated password, which is marked expired\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
No anonymous\-user accounts are created\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
No
test
database accessible by all users is created\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-admin\-\fR\fB\fIxxx\fR\fR
options are available to control characteristics of the administrative account\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
The
\fB\-\-random\-password\-file\fR
option is available to control where the random password is written\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
The
\fB\-\-insecure\fR
option is available to suppress random password generation\&.
.RE
.PP
If
\fBmysql_install_db\fR
generates a random administative password, it writes the password to a file and displays the file name\&. The password entry includes a timestamp to indicate when it was written\&. By default, the file is
\&.mysql_secret
in the home directory of the effective user running the script\&.
\&.mysql_secret
is created with mode 600 to be accessible only to the operating system user for whom it is created\&.
.if n \{\
.sp
.\}
.RS 4
.it 1 an-trap
.nr an-no-space-flag 1
.nr an-break-flag 1
.br
.ps +1
\fBImportant\fR
.ps -1
.br
.PP
When
\fBmysql_install_db\fR
generates a random password for the administrative account, it is necessary after
\fBmysql_install_db\fR
has been run to start the server, connect using the administrative account with the password written to the
\&.mysql_secret
file, and specify a new administrative password\&. Until this is done, the administrative account cannot be used for anything else\&. To change the password, you can use the
SET PASSWORD
statement (for example, with the
\fBmysql\fR
or
\fBmysqladmin\fR
client)\&. After resetting the password, remove the
\&.mysql_secret
file; otherwise, if you run
\fBmysql_secure_installation\fR, that command may see the file and expire the
root
password again as part of ensuring secure deployment\&.
.sp .5v
.RE
Invocation Syntax
.PP
Change location to the MySQL installation directory and use this invocation syntax:
.sp
.if n \{\
.RS 4
.\}
.nf
bin/mysql_install_db \-\-datadir=\fIpath/to/datadir\fR [\fIother_options\fR]
.fi
.if n \{\
.RE
.\}
.PP
The
\fB\-\-datadir\fR
option is mandatory\&.
\fBmysql_install_db\fR
creates the data directory, which must not already exist:
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
If the data directory does already exist, you are performing an upgrade operation (not an install operation) and should run
\fBmysql_upgrade\fR, not
\fBmysql_install_db\fR\&. See
mysql_upgrade(1)\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
If the data directory does not exist but
\fBmysql_install_db\fR
fails, you must remove any partially created data directory before running
\fBmysql_install_db\fR
again\&.
.RE
.PP
Because the MySQL server,
\fBmysqld\fR, must access the data directory when it runs later, you should either run
\fBmysql_install_db\fR
from the same system account used for running
\fBmysqld\fR, or run it as
root
and specify the
\fB\-\-user\fR
option to indicate the user name that
\fBmysqld\fR
runs under\&. It might be necessary to specify other options such as
\fB\-\-basedir\fR
if
\fBmysql_install_db\fR
does not use the correct location for the installation directory\&. For example:
.sp
.if n \{\
.RS 4
.\}
.nf
bin/mysql_install_db \-\-user=mysql \e
    \-\-basedir=/opt/mysql/mysql \e
    \-\-datadir=/opt/mysql/mysql/data
.fi
.if n \{\
.RE
.\}
.sp
.if n \{\
.sp
.\}
.RS 4
.it 1 an-trap
.nr an-no-space-flag 1
.nr an-break-flag 1
.br
.ps +1
\fBNote\fR
.ps -1
.br
.PP
After
\fBmysql_install_db\fR
sets up the
InnoDB
system tablespace, changes to some tablespace characteristics require setting up a whole new
instance\&. This includes the file name of the first file in the system tablespace and the number of undo logs\&. If you do not want to use the default values, make sure that the settings for the
innodb_data_file_path
and
innodb_log_file_size
configuration parameters are in place in the MySQL
configuration file
before running
\fBmysql_install_db\fR\&. Also make sure to specify as necessary other parameters that affect the creation and location of
InnoDB
files, such as
innodb_data_home_dir
and
innodb_log_group_home_dir\&.
.PP
If those options are in your configuration file but that file is not in a location that MySQL reads by default, specify the file location using the
\fB\-\-defaults\-extra\-file\fR
option when you run
\fBmysql_install_db\fR\&.
.sp .5v
.RE
.if n \{\
.sp
.\}
.RS 4
.it 1 an-trap
.nr an-no-space-flag 1
.nr an-break-flag 1
.br
.ps +1
\fBNote\fR
.ps -1
.br
.PP
If you have set a custom
TMPDIR
environment variable when performing the installation, and the specified directory is not accessible,
\fBmysql_install_db\fR
may fail\&. If so, unset
TMPDIR
or set
TMPDIR
to point to the system temporary directory (usually
/tmp)\&.
.sp .5v
.RE
Administrative Account Creation
.PP
\fBmysql_install_db\fR
creates an administrative account named
\*(Aqroot\*(Aq@\*(Aqlocalhost\*(Aq
by default\&.
.PP
\fBmysql_install_db\fR
provides options that enable you to control several aspects of the administrative account:
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
To change the user or host parts of the account name, use
\fB\-\-login\-path\fR, or
\fB\-\-admin\-user\fR
and
\fB\-\-admin\-host\fR\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-insecure\fR
suppresses generation of a random password\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-admin\-auth\-plugin\fR
specifies the authentication plugin\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-admin\-require\-ssl\fR
specifies whether the account must use SSL connections\&.
.RE
.PP
For more information, see the descriptions of those options\&.
.PP
\fBmysql_install_db\fR
assigns
mysql\&.user
system table rows a nonempty
plugin
column value to set the authentication plugin\&. The default value is
mysql_native_password\&. The value can be changed using the
\fB\-\-admin\-auth\-plugin\fR
option\&.
Default my\&.cnf File
.PP
\fBmysql_install_db\fR
creates no default
my\&.cnf
file\&.
.if n \{\
.sp
.\}
.RS 4
.it 1 an-trap
.nr an-no-space-flag 1
.nr an-break-flag 1
.br
.ps +1
\fBNote\fR
.ps -1
.br
.PP
As of MySQL 5\&.7\&.18,
my\-default\&.cnf
is no longer included in or installed by distribution packages\&.
.sp .5v
.RE
.PP
With one exception, the settings in the default option file are commented and have no effect\&. The exception is that the file sets the
sql_mode
system variable to
NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES\&. This setting produces a server configuration that results in errors rather than warnings for bad data in operations that modify transactional tables\&. See
Section\ \&5.1.10, \(lqServer SQL Modes\(rq\&.
Command Options
.PP
\fBmysql_install_db\fR
supports the following options, which can be specified on the command line or in the
[mysql_install_db]
group of an option file\&. For information about option files used by MySQL programs, see
Section\ \&4.2.2.2, \(lqUsing Option Files\(rq\&.
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-help\fR,
\fB\-?\fR
Display a help message and exit\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-admin\-auth\-plugin=\fR\fB\fIplugin_name\fR\fR
The authentication plugin to use for the administrative account\&. The default is
mysql_native_password\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-admin\-host=\fR\fB\fIhost_name\fR\fR
The host part to use for the adminstrative account name\&. The default is
localhost\&. This option is ignored if
\fB\-\-login\-path\fR
is also specified\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-admin\-require\-ssl\fR
Whether to require SSL for the administrative account\&. The default is not to require it\&. With this option enabled, the statement that
\fBmysql_install_db\fR
uses to create the account includes a
REQUIRE SSL
clause\&. As a result, the administrative account must use secure connections when connecting to the server\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-admin\-user=\fR\fB\fIuser_name\fR\fR
The user part to use for the adminstrative account name\&. The default is
root\&. This option is ignored if
\fB\-\-login\-path\fR
is also specified\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-basedir=\fR\fB\fIdir_name\fR\fR
The path to the MySQL installation directory\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-builddir=\fR\fB\fIdir_name\fR\fR
For use with
\fB\-\-srcdir\fR
and out\-of\-source builds\&. Set this to the location of the directory where the built files reside\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-datadir=\fR\fB\fIdir_name\fR\fR
The path to the MySQL data directory\&. Only the last component of the path name is created if it does not exist; the parent directory must already exist or an error occurs\&.
.if n \{\
.sp
.\}
.RS 4
.it 1 an-trap
.nr an-no-space-flag 1
.nr an-break-flag 1
.br
.ps +1
\fBNote\fR
.ps -1
.br
The
\fB\-\-datadir\fR
option is mandatory and the data directory must not already exist\&.
.sp .5v
.RE
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-defaults\fR
This option causes
\fBmysql_install_db\fR
to invoke
\fBmysqld\fR
in such a way that it reads option files from the default locations\&. If given as
\fB\-\-no\-defaults\fR, and
\fB\-\-defaults\-file\fR
or
\fB\-\-defaults\-extra\-file\fR
is not also specified,
\fBmysql_install_db\fR
passes
\fB\-\-no\-defaults\fR
to
\fBmysqld\fR, to prevent option files from being read\&. This may help if program startup fails due to reading unknown options from an option file\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-defaults\-extra\-file=\fR\fB\fIfile_name\fR\fR
Read this option file after the global option file but (on Unix) before the user option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&. If
\fIfile_name\fR
is not an absolute path name, it is interpreted relative to the current directory\&.
.sp
This option is passed by
\fBmysql_install_db\fR
to
\fBmysqld\fR\&.
.sp
For additional information about this and other option\-file options, see
Section\ \&4.2.2.3, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-defaults\-file=\fR\fB\fIfile_name\fR\fR
Use only the given option file\&. If the file does not exist or is otherwise inaccessible, an error occurs\&. If
\fIfile_name\fR
is not an absolute path name, it is interpreted relative to the current directory\&.
.sp
This option is passed by
\fBmysql_install_db\fR
to
\fBmysqld\fR\&.
.sp
For additional information about this and other option\-file options, see
Section\ \&4.2.2.3, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-extra\-sql\-file=\fR\fB\fIfile_name\fR\fR,
\fB\-f \fR\fB\fIfile_name\fR\fR
This option names a file containing additional SQL statements to be executed after the standard bootstrapping statements\&. Accepted statement syntax in the file is like that of the
\fBmysql\fR
command\-line client, including support for multiple\-line C\-style comments and delimiter handling to enable definition of stored programs\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-insecure\fR
Do not generate a random password for the adminstrative account\&.
.sp
If
\fB\-\-insecure\fR
is
\fInot\fR
given, it is necessary after
\fBmysql_install_db\fR
has been run to start the server, connect using the administrative account with the password written to the
\&.mysql_secret
file, and specify a new administrative password\&. Until this is done, the administrative account cannot be used for anything else\&. To change the password, you can use the
SET PASSWORD
statement (for example, with the
\fBmysql\fR
or
\fBmysqladmin\fR
client)\&. After resetting the password, remove the
\&.mysql_secret
file; otherwise, if you run
\fBmysql_secure_installation\fR, that command may see the file and expire the
root
password again as part of ensuring secure deployment\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-lc\-messages=name\fR
The locale to use for error messages\&. The default is
en_US\&. The argument is converted to a language name and combined with the value of
\fB\-\-lc\-messages\-dir\fR
to produce the location for the error message file\&. See
Section\ \&10.12, \(lqSetting the Error Message Language\(rq\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-lc\-messages\-dir=\fR\fB\fIdir_name\fR\fR
The directory where error messages are located\&. The value is used together with the value of
\fB\-\-lc\-messages\fR
to produce the location for the error message file\&. See
Section\ \&10.12, \(lqSetting the Error Message Language\(rq\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-login\-file=\fR\fB\fIfile_name\fR\fR
The file from which to read the login path if the
\fB\-\-login\-path=\fR\fB\fIfile_name\fR\fR
option is specified\&. The default file is
\&.mylogin\&.cnf\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-login\-path=\fR\fB\fIname\fR\fR
Read options from the named login path in the
\&.mylogin\&.cnf
login path file\&. The default login path is
client\&. (To read a different file, use the
\fB\-\-login\-file=\fR\fB\fIname\fR\fR
option\&.) A
\(lqlogin path\(rq
is an option group containing options that specify which MySQL server to connect to and which account to authenticate as\&. To create or modify a login path file, use the
\fBmysql_config_editor\fR
utility\&. See
mysql_config_editor(1)\&.
.sp
If the
\fB\-\-login\-path\fR
option is specified, the user, host, and password values are taken from the login path and used to create the administrative account\&. The password must be defined in the login path or an error occurs, unless the
\fB\-\-insecure\fR
option is also specified\&. In addition, with
\fB\-\-login\-path\fR, any
\fB\-\-admin\-host\fR
and
\fB\-\-admin\-user\fR
options are ignored\&.
.sp
For additional information about this and other option\-file options, see
Section\ \&4.2.2.3, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-mysqld\-file=\fR\fB\fIfile_name\fR\fR
The path name of the
\fBmysqld\fR
binary to execute\&. The option value must be an absolute path name or an error occurs\&.
.sp
If this option is not given,
\fBmysql_install_db\fR
searches for
\fBmysqld\fR
in these locations:
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
In the
bin
directory under the
\fB\-\-basedir\fR
option value, if that option was given\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
In the
bin
directory under the
\fB\-\-srcdir\fR
option value, if that option was given\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
In the
bin
directory under the
\fB\-\-builddir\fR
option value, if that option was given\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
In the local directory and in the
bin
and
sbin
directories under the local directory\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
In
/usr/bin,
/usr/sbin,
/usr/local/bin,
/usr/local/sbin,
/opt/local/bin,
/opt/local/sbin\&.
.RE
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-no\-defaults\fR
For behavior of this option, see the description of
\fB\-\-defaults\fR\&.
.sp
For additional information about this and other option\-file options, see
Section\ \&4.2.2.3, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-random\-password\-file=\fR\fB\fIfile_name\fR\fR
The path name of the file in which to write the randomly generated password for the administrative account\&. The option value must be an absolute path name or an error occurs\&. The default is
$HOME/\&.mysql_secret\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-skip\-sys\-schema\fR
\fBmysql_install_db\fR
installs the
sys
schema\&. The
\fB\-\-skip\-sys\-schema\fR
option suppresses this behavior\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-srcdir=\fR\fB\fIdir_name\fR\fR
For internal use\&. This option specifies the directory under which
\fBmysql_install_db\fR
looks for support files such as the error message file and the file for populating the help tables\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-user=\fR\fB\fIuser_name\fR\fR,
\fB\-u \fR\fB\fIuser_name\fR\fR
The system (login) user name to use for running
\fBmysqld\fR\&. Files and directories created by
\fBmysqld\fR
are owned by this user\&. You must be the system
root
user to use this option\&. By default,
\fBmysqld\fR
runs using your current login name; files and directories that it creates are owned by you\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-verbose\fR,
\fB\-v\fR
Verbose mode\&. Print more information about what the program does\&. You can use this option to see the
\fBmysqld\fR
command that
\fBmysql_install_db\fR
invokes to start the server in bootstrap mode\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fB\-\-version\fR,
\fB\-V\fR
Display version information and exit\&.
.RE
.SH "COPYRIGHT"
.br
.PP
Copyright \(co 1997, 2022, Oracle and/or its affiliates.
.PP
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
.PP
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
.PP
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
.sp
.SH "SEE ALSO"
For more information, please refer to the MySQL Reference Manual,
which may already be installed locally and which is also available
online at http://dev.mysql.com/doc/.
.SH AUTHOR
Oracle Corporation (http://dev.mysql.com/).

${this.title}

Code Editor : mysql_install_db.1