MySQL Installer performs the initial configuration of the MySQL server. For example:MySQL安装程序执行MySQL服务器的初始配置。例如
It creates the configuration file (它创建用于配置MySQL服务器的配置文件(my.ini
) that is used to configure the MySQL server. my.ini
)。The values written to this file are influenced by choices you make during the installation process. Some definitions are host dependent. For example, query_cache is enabled if the host has fewer than three cores.写入此文件的值会受到您在安装过程中所做选择的影响。某些定义与主机有关。例如,如果主机的内核少于三个,则会启用query_cache。
Query cache was deprecated in MySQL 5.7 and removed in MySQL 8.0 (and later).查询缓存在MySQL 5.7中被弃用,在MySQL 8.0(及更高版本)中被删除。
By default, a Windows service for the MySQL server is added.默认情况下,会为MySQL服务器添加一个Windows服务。
Provides default installation and data paths for MySQL server. 提供MySQL服务器的默认安装和数据路径。For instructions on how to change the default paths, see Section 2.3.3.2, “Setting Alternative Server Paths with MySQL Installer”.有关如何更改默认路径的说明,请参阅第2.3.3.2节,“使用MySQL安装程序设置备用服务器路径”。
It can optionally create MySQL server user accounts with configurable permissions based on general roles, such as DB Administrator, DB Designer, and Backup Admin. 它可以根据常规角色(如数据库管理员、数据库设计器和备份管理员)选择创建具有可配置权限的MySQL服务器用户帐户。It optionally creates a Windows user named 它可以选择创建一个名为MysqlSys
with limited privileges, which would then run the MySQL Server.MysqlSys
的具有有限权限的Windows用户,然后运行MySQL Server。
User accounts may also be added and configured in MySQL Workbench.用户帐户也可以在MySQL Workbench中添加和配置。
Checking Show Advanced Options enables additional Logging Options to be set. 选中“显示高级选项”可以设置其他“日志记录选项”。This includes defining custom file paths for the error log, general log, slow query log (including the configuration of seconds it requires to execute a query), and the binary log.这包括为错误日志、常规日志、慢速查询日志(包括执行查询所需的秒数配置)和二进制日志定义自定义文件路径。
During the configuration process, click 在配置过程中,单击“下一步”继续下一步,或单击“上一步”返回上一步。 to proceed to the next step or to return to the previous step. Click 在最后一步单击“执行”以应用服务器配置。 at the final step to apply the server configuration.
The sections that follow describe the server configuration options that apply to MySQL server on Windows. The server version you installed will determine which steps and options you can configure. 以下部分介绍了适用于Windows上MySQL服务器的服务器配置选项。您安装的服务器版本将决定您可以配置哪些步骤和选项。Configuring MySQL server may include some or all of the steps.配置MySQL服务器可能包括部分或全部步骤。