您可以为root账户设置密码。You can set a password for root accounts.

您可以移除可以从本地主机外部访问的root账户。You can remove root accounts that are accessible from outside the local host.

您可以删除匿名用户账户。You can remove anonymous-user accounts.

你可以删除 test 数据库（默认情况下，所有用户甚至匿名用户都可以访问），以及允许任何人访问以 test_ 开头命名的数据库的权限。You can remove the test database (which by default can be accessed by all users, even anonymous users), and privileges that permit anyone to access databases with names that start with test_.

--help, -? --help, -?

显示帮助信息并退出。Display a help message and exit.

--defaults-extra-file=file_name --defaults-extra-file=file_name

在全局选项文件之后读取此选项文件，但（在 Unix 系统上）在用户选项文件之前。如果该文件不存在或无法访问，将发生错误。如果 file_name 不是绝对路径名，则相对于当前目录解释。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 file_name is not an absolute path name, it is interpreted relative to the current directory.

有关此选项文件选项及其他选项文件选项的更多信息，请参见 第 6.2.2.3 节，“影响选项文件处理的命令行选项”。For additional information about this and other option-file options, see Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”.

--defaults-file=file_name --defaults-file=file_name

仅使用指定的选项文件。如果文件不存在或无法访问，将会发生错误。如果file_name不是绝对路径名，则将其相对于当前目录解释。Use only the given option file. If the file does not exist or is otherwise inaccessible, an error occurs. If file_name is not an absolute path name, it is interpreted relative to the current directory.

有关此选项文件选项及其他选项文件选项的更多信息，请参见 第 6.2.2.3 节，“影响选项文件处理的命令行选项”。For additional information about this and other option-file options, see Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”.

--defaults-group-suffix=str --defaults-group-suffix=str

不仅要读取常规的选项组，还要读取带有常规名称并加上 str 后缀的组。例如，mysql_secure_installation 通常会读取 [client] 和 [mysql_secure_installation] 组。如果此选项被指定为 --defaults-group-suffix=_other，mysql_secure_installation 也会读取 [client_other] 和 [mysql_secure_installation_other] 组。Read not only the usual option groups, but also groups with the usual names and a suffix of str. For example, mysql_secure_installation normally reads the [client] and [mysql_secure_installation] groups. If this option is given as --defaults-group-suffix=_other, mysql_secure_installation also reads the [client_other] and [mysql_secure_installation_other] groups.

有关此选项文件选项及其他选项文件选项的更多信息，请参见 第 6.2.2.3 节，“影响选项文件处理的命令行选项”。For additional information about this and other option-file options, see Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”.

--host=host_name, -h host_name --host=host_name, -h host_name

连接到给定主机上的 MySQL 服务器。Connect to the MySQL server on the given host.

--no-defaults --no-defaults

不读取任何选项文件。如果程序启动因从选项文件中读取未知选项而失败，可以使用 --no-defaults 来防止读取它们。Do not read any option files. If program startup fails due to reading unknown options from an option file, --no-defaults can be used to prevent them from being read.

例外情况是，无论如何都会读取 .mylogin.cnf 文件，如果它存在的话。这允许即使使用 --no-defaults 时，也能以比命令行更安全的方式指定密码。要创建 .mylogin.cnf，请使用 mysql_config_editor 工具。参见 第 6.6.7 节，“mysql_config_editor — MySQL 配置工具”。The exception is that the .mylogin.cnf file is read in all cases, if it exists. This permits passwords to be specified in a safer way than on the command line even when --no-defaults is used. To create .mylogin.cnf, use the mysql_config_editor utility. See Section 6.6.7, “mysql_config_editor — MySQL Configuration Utility”.

有关此选项文件选项及其他选项文件选项的更多信息，请参见 第 6.2.2.3 节，“影响选项文件处理的命令行选项”。For additional information about this and other option-file options, see Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”.

--password=password, -p password --password=password, -p password

此选项被接受但会被忽略。无论是否使用此选项，mysql_secure_installation 总是会提示用户输入密码。This option is accepted but ignored. Whether or not this option is used, mysql_secure_installation always prompts the user for a password.

--port=port_num, -P port_num --port=port_num, -P port_num

对于 TCP/IP 连接，要使用的端口号。For TCP/IP connections, the port number to use.

--print-defaults --print-defaults

打印程序名称以及它从选项文件中获取的所有选项。Print the program name and all options that it gets from option files.

有关此选项文件选项及其他选项文件选项的更多信息，请参见 第 6.2.2.3 节，“影响选项文件处理的命令行选项”。For additional information about this and other option-file options, see Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”.

--protocol={TCP|SOCKET|PIPE|MEMORY}

用于连接服务器的传输协议。当其他连接参数通常导致使用的协议不是您想要的协议时，这很有用。有关允许值的详细信息，请参阅第 6.2.7 节，“连接传输协议”。The transport protocol to use for connecting to the server. It is useful when the other connection parameters normally result in use of a protocol other than the one you want. For details on the permissible values, see Section 6.2.7, “Connection Transport Protocols”.

--socket=path, -S path --socket=path, -S path

用于连接localhost时，使用的 Unix 套接字文件，或者在 Windows 上使用的命名管道的名称。For connections to localhost, the Unix socket file to use, or, on Windows, the name of the named pipe to use.

在 Windows 上，只有在服务器启动时启用了named_pipe系统变量以支持命名管道连接时，此选项才适用。此外，连接必须是由named_pipe_full_access_group系统变量指定的 Windows 组成员。On Windows, this option applies only if the server was started with the named_pipe system variable enabled to support named-pipe connections. In addition, the connection must be a member of the Windows group specified by the named_pipe_full_access_group system variable.

--ssl*

以--ssl开头的选项指定是否使用加密连接到服务器，并指示在哪里可以找到 SSL 密钥和证书。请参阅 加密连接的命令选项。Options that begin with --ssl specify whether to connect to the server using encryption and indicate where to find SSL keys and certificates. See Command Options for Encrypted Connections.

--ssl-fips-mode={OFF|ON|STRICT}

控制是否在客户端启用 FIPS 模式。--ssl-fips-mode 选项不同于其他 --ssl-xxx 选项，它不是用于建立加密连接，而是用于影响允许的加密操作。请参见 第 8.8 节，“FIPS 支持”。Controls whether to enable FIPS mode on the client side. The --ssl-fips-mode option differs from other --ssl-xxx options in that it is not used to establish encrypted connections, but rather to affect which cryptographic operations to permit. See Section 8.8, “FIPS Support”.

这些 --ssl-fips-mode 值是允许的：These --ssl-fips-mode values are permitted:

此选项已弃用。预计将在未来的 MySQL 版本中移除。This option is deprecated. Expect it to be removed in a future version of MySQL.

--tls-ciphersuites=ciphersuite_list --tls-ciphersuites=ciphersuite_list

用于 TLSv1.3 加密连接的允许密码套件。该值是一个或多个用冒号分隔的密码套件名称的列表。此选项可指定的密码套件取决于用于编译 MySQL 的 SSL 库。有关详细信息，请参见 第 8.3.2 节，“加密连接的 TLS 协议和密码”。The permissible ciphersuites for encrypted connections that use TLSv1.3. The value is a list of one or more colon-separated ciphersuite names. The ciphersuites that can be named for this option depend on the SSL library used to compile MySQL. For details, see Section 8.3.2, “Encrypted Connection TLS Protocols and Ciphers”.

--tls-sni-servername=server_name --tls-sni-servername=server_name

如果指定了名称，该名称将通过 mysql_options() 的 MYSQL_OPT_TLS_SNI_SERVERNAME 选项传递给 libmysqlclient C API 库。服务器名称不区分大小写。要显示客户端为当前会话指定的服务器名称（如果有），请检查 Tls_sni_server_name 状态变量。When specified, the name is passed to the libmysqlclient C API library using the MYSQL_OPT_TLS_SNI_SERVERNAME option of mysql_options(). The server name is not case-sensitive. To show which server name the client specified for the current session, if any, check the Tls_sni_server_name status variable.

服务器名称指示（SNI）是 TLS 协议的一个扩展（必须使用支持 TLS 扩展的 OpenSSL 编译此选项才能生效）。MySQL 对 SNI 的实现仅代表客户端。Server Name Indication (SNI) is an extension to the TLS protocol (OpenSSL must be compiled using TLS extensions for this option to function). The MySQL implementation of SNI represents the client-side only.

--tls-version=protocol_list --tls-version=protocol_list

用于加密连接的允许 TLS 协议。值是一个或多个以逗号分隔的协议名称列表。此选项可指定的协议取决于用于编译 MySQL 的 SSL 库。详情请参见 第 8.3.2 节，“加密连接 TLS 协议和密码”。The permissible TLS protocols for encrypted connections. The value is a list of one or more comma-separated protocol names. The protocols that can be named for this option depend on the SSL library used to compile MySQL. For details, see Section 8.3.2, “Encrypted Connection TLS Protocols and Ciphers”.

--use-default

非交互式执行。此选项可用于无人值守的安装操作。Execute noninteractively. This option can be used for unattended installation operations.

--user=user_name, -u user_name --user=user_name, -u user_name

用于连接服务器的 MySQL 帐户用户名。The user name of the MySQL account to use for connecting to the server.