Server Configuration Type服务器配置类型
Choose the MySQL server configuration type that describes your setup. This setting defines the amount of system resources (memory) to assign to your MySQL server instance.选择描述您的设置的MySQL服务器配置类型。此设置定义要分配给MySQL服务器实例的系统资源(内存)量。
Development发展: A computer that hosts many other applications, and typically this is your personal workstation. :承载许多其他应用程序的计算机,通常这是您的个人工作站。This setting configures MySQL to use the least amount of memory.此设置将MySQL配置为使用最少的内存。
Server服务器: Several other applications are expected to run on this computer, such as a web server. The Server setting configures MySQL to use a medium amount of memory.:其他几个应用程序预计将在此计算机上运行,例如web服务器。服务器设置将MySQL配置为使用中等数量的内存。
Dedicated独占的: A computer that is dedicated to running the MySQL server. Because no other major applications run on this server, this setting configures MySQL to use the majority of available memory.:一台专门用于运行MySQL服务器的计算机。由于此服务器上没有其他主要应用程序运行,因此此设置将MySQL配置为使用大部分可用内存。
Connectivity连通性
Connectivity options control how the connection to MySQL is made. Options include:连接选项控制如何连接到MySQL。选项包括:
TCP/IP: This option is selected by default. You may disable TCP/IP Networking to permit local host connections only. With the TCP/IP connection option selected, you can modify the following items::默认情况下会选择此选项。您可以禁用TCP/IP网络以仅允许本地主机连接。选择TCP/IP连接选项后,可以修改以下项目:
Port for classic MySQL protocol connections. 经典MySQL协议连接的“端口”。The default value is 默认值为3306
.3306
。
X Protocol Port shown when configuring MySQL 8.0 server only. The default value is 仅配置MySQL 8.0服务器时显示的“X协议端口”。默认值为33060
33060
Open Windows Firewall port for network access, which is selected by default for TCP/IP connections.“打开用于网络访问的Windows防火墙端口”,默认情况下为TCP/IP连接选择该端口。
If a port number is in use already, you will see the information icon (如果端口号已在使用中,您将看到默认值旁边的信息图标() next to the default value and is disabled until you provide a new port number.
),并且在提供新端口号之前,“下一步”将被禁用。
Named Pipe命名管道: Enable and define the pipe name, similar to setting the :启用并定义管道名称,类似于设置named_pipe
system variable. named_pipe
系统变量。The default name is 默认名称为MySQL
.MySQL
。
Shared Memory共享内存: Enable and define the memory name, similar to setting the :启用并定义内存名称,类似于设置shared_memory
system variable. shared_memory
系统变量。The default name is 默认名称为MySQL
.MySQL
。
Advanced Configuration高级配置
Check Show Advanced and Logging Options to set custom logging and advanced options in later steps. 选中“显示高级”和“日志记录选项”可在以后的步骤中设置自定义日志记录和高级选项。The Logging Options step enables you to define 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. “日志记录选项”步骤使您能够为错误日志、常规日志、慢速查询日志(包括执行查询所需的秒数配置)和二进制日志定义自定义文件路径。The Advanced Options step enables you to set the unique server ID required when binary logging is enabled in a replication topology.“高级选项”步骤使您能够设置在复制拓扑中启用二进制日志记录时所需的唯一服务器ID。
MySQL Enterprise Firewall (Enterprise Edition only)MySQL企业防火墙(仅限企业版)
The Enable MySQL Enterprise Firewall check box is deselected by default. Select this option to enable a security list that offers protection against certain types of attacks. 默认情况下,将取消选中“启用MySQL企业防火墙”复选框。选择此选项可启用一个安全列表,该列表提供针对特定类型攻击的保护。Additional post-installation configuration is required (see Section 6.4.7, “MySQL Enterprise Firewall”).需要额外的安装后配置(请参阅第6.4.7节,“MySQL企业防火墙”)。
There is an issue for MySQL 8.0.19 that prevents the server from starting if MySQL Enterprise Firewall is selected during the server configuration steps. MySQL 8.0.19存在一个问题,如果在服务器配置步骤中选择了MySQL Enterprise Firewall,则会阻止服务器启动。If the server startup operation fails, click 如果服务器启动操作失败,请单击“取消”结束配置过程并返回仪表板。您必须卸载服务器。 to end the configuration process and return to the dashboard. You must uninstall the server.
The workaround is to run MySQL Installer without MySQL Enterprise Firewall selected. (That is, do not select the Enable MySQL Enterprise Firewall check box.) 解决方法是在不选择MySQL企业防火墙的情况下运行MySQL安装程序。(也就是说,不要选中“启用MySQL企业防火墙”复选框。)Then install MySQL Enterprise Firewall afterward using the instructions for manual installation (see Section 6.4.7.2, “Installing or Uninstalling MySQL Enterprise Firewall”).然后按照手动安装说明安装MySQL Enterprise Firewall(请参阅第6.4.7.2节,“安装或卸载MySQL Enterprise Firewalls”)。