This step is available if the Show Advanced Configuration check box was selected during the Type and Networking step. 如果在“类型和网络”步骤中选中了“显示高级配置”复选框,则此步骤可用。To enable this step now, click Type and Networking step and select the check box.要立即启用此步骤,请单击“上一步”返回“类型和网络”步骤并选中复选框。 to return to the
The advanced-configuration options include:高级配置选项包括:
Server ID服务器ID
Set the unique identifier used in a replication topology. 设置复制拓扑中使用的唯一标识符。If binary logging is enabled, you must specify a server ID. The default ID value depends on the server version. 如果启用了二进制日志记录,则必须指定服务器ID。默认ID值取决于服务器版本。For more information, see the description of the 有关更多信息,请参阅server_id
system variable.server_id
系统变量的描述。
Table Names Case表名称大小写
You can set the following options during the initial and subsequent configuration the server. For the MySQL 8.0 release series, these options apply only to the initial configuration of the server.您可以在服务器的初始和后续配置过程中设置以下选项。对于MySQL 8.0版本系列,这些选项仅适用于服务器的初始配置。
Lower Case小写
Sets the 将lower_case_table_names
option value to 1 (default), in which table names are stored in lowercase on disk and comparisons are not case-sensitive.lower_case_table_names
选项值设置为1(默认值),其中表名以小写形式存储在磁盘上,并且比较不区分大小写。
Preserve Given Case保留给定案例
Sets the 将lower_case_table_names
option value to 2, in which table names are stored as given but compared in lowercase.lower_case_table_names
选项值设置为2,其中表名按给定值存储,但以小写进行比较。