1、[server]和[mysqld]的區(qū)別,沒(méi)有看到官方文檔，個(gè)人感覺(jué)server指整臺(tái)服務(wù)器，mysqld指實(shí)例，當(dāng)一臺(tái)服務(wù)器上多個(gè)實(shí)例使用同一個(gè)配置文件my.cnf時(shí),[server]通用于所有實(shí)例，[mysqld_3306] [[mysqld_3307] [mysqld_3308]對(duì)應(yīng)單獨(dú)實(shí)例

為阿合奇等地區(qū)用戶提供了全套網(wǎng)頁(yè)設(shè)計(jì)制作服務(wù)，及阿合奇網(wǎng)站建設(shè)行業(yè)解決方案。主營(yíng)業(yè)務(wù)為成都網(wǎng)站設(shè)計(jì)、成都網(wǎng)站制作、阿合奇網(wǎng)站設(shè)計(jì)，以傳統(tǒng)方式定制建設(shè)網(wǎng)站，并提供域名空間備案等一條龍服務(wù)，秉承以專業(yè)、用心的態(tài)度為用戶提供真誠(chéng)的服務(wù)。我們深信只要達(dá)到每一位用戶的要求，就會(huì)得到認(rèn)可，從而選擇與我們長(zhǎng)期合作。這樣，我們也可以走得更遠(yuǎn)！

2、mysqld從[mysqld]和[server]組中讀取選項(xiàng)。 mysqld_safe從[mysqld]，[server]，[mysqld_safe]和[safe_mysqld]組中讀取選項(xiàng)。 mysql.server從[mysqld]和[mysql.server]組中讀取選項(xiàng)。

3、[client]組更通用，因?yàn)樗凰锌蛻舳顺绦蜃x取，而[mysqldump]組只能由mysqldump讀取

4、后面的選項(xiàng)會(huì)覆蓋前面的選項(xiàng)，比如按[client]，[mysqldump]的順序放置選項(xiàng)組，則[mysqldump]選項(xiàng)會(huì)覆蓋[client]選項(xiàng)

/tupian/20230522/option-files.html

[group]

group is the name of the program or group for which you want to set options. After a group line, any option-setting lines apply to the named group until the end of the option file or another group line is given. Option group names are not case-sensitive.

group是要為其設(shè)置選項(xiàng)的程序或組的名稱。 在組行之后，任何選項(xiàng)設(shè)置行都將應(yīng)用于命名組，直到選項(xiàng)文件的末尾或另一個(gè)組行為止。 選項(xiàng)組名稱不區(qū)分大小寫(xiě)。

If an option group name is the same as a program name, options in the group apply specifically to that program. For example, the [mysqld] and [mysql] groups apply to the mysqld server and the mysql client program, respectively.

The [client] option group is read by all client programs provided in MySQL distributions (but not by mysqld). 

如果選項(xiàng)組名稱與程序名稱相同，則組中的選項(xiàng)將專門(mén)應(yīng)用于該程序。 例如，[mysqld]和[mysql]組分別應(yīng)用于mysqld服務(wù)器和mysql客戶端程序。

[client]選項(xiàng)組由MySQL發(fā)行版中提供的所有客戶端程序讀取（但不是由mysqld提供）。

The [client] group enables you to specify options that apply to all clients. For example, [client] is the appropriate group to use to specify the password for connecting to the server. (But make sure that the option file is accessible only by yourself, so that other people cannot discover your password.) Be sure not to put an option in the [client] group unless it is recognized by all client programs that you use. Programs that do not understand the option quit after displaying an error message if you try to run them.

List more general option groups first and more specific groups later. For example, a [client] group is more general because it is read by all client programs, whereas a [mysqldump] group is read only by mysqldump. Options specified later override options specified earlier, so putting the option groups in the order [client], [mysqldump] enables mysqldump-specific options to override [client] options.

[client]組使您可以指定適用于所有客戶端的選項(xiàng)。 例如，[client]是用于指定連接到服務(wù)器的密碼的適當(dāng)組。 （但請(qǐng)確保選項(xiàng)文件只能由您自己訪問(wèn)，以便其他人無(wú)法發(fā)現(xiàn)您的密碼。）請(qǐng)確保不要在[client]組中添加選項(xiàng)，除非您使用的所有客戶端程序都能識(shí)別它。 如果您嘗試運(yùn)行錯(cuò)誤消息，則在顯示錯(cuò)誤消息后，不理解該選項(xiàng)的程序?qū)⑼顺觥?/p>

首先列出更多通用選項(xiàng)組，稍后列出更具體的組。 例如，[client]組更通用，因?yàn)樗凰锌蛻舳顺绦蜃x取，而[mysqldump]組只能由mysqldump讀取。 稍后指定的選項(xiàng)會(huì)覆蓋先前指定的選項(xiàng)，因此按[client]，[mysqldump]的順序放置選項(xiàng)組會(huì)啟用特定于mysqldump的選項(xiàng)來(lái)覆蓋[client]選項(xiàng)。

To create option groups to be read only by mysqld servers from specific MySQL release series, use groups with names of [mysqld-5.6], [mysqld-5.7], and so forth. The following group indicates that the sql_mode setting should be used only by MySQL servers with 5.7.x version numbers:

[mysqld-5.7]

sql_mode=TRADITIONAL

要?jiǎng)?chuàng)建僅由特定MySQL發(fā)行系列中的mysqld服務(wù)器讀取的選項(xiàng)組，請(qǐng)使用名稱為[mysqld-5.6]，[mysqld-5.7]等的組。 以下組表示sql_mode設(shè)置應(yīng)僅由具有5.7.x版本號(hào)的MySQL服務(wù)器使用：

[mysqld-5.7]

sql_mode=TRADITIONAL

Write the contents of an included option file like any other option file. That is, it should contain groups of options, each preceded by a [group] line that indicates the program to which the options apply.

像任何其他選項(xiàng)文件一樣寫(xiě)入包含的選項(xiàng)文件的內(nèi)容。 也就是說(shuō)，它應(yīng)該包含選項(xiàng)組，每個(gè)選項(xiàng)前面都有一個(gè)[group]行，表示選項(xiàng)適用的程序。

/tupian/20230522/server-options.html

mysqld reads options from the [mysqld] and [server] groups. mysqld_safe reads options from the [mysqld], [server], [mysqld_safe], and [safe_mysqld] groups. mysql.server reads options from the [mysqld] and [mysql.server] groups.

An embedded MySQL server usually reads options from the [server], [embedded], and [xxxxx_SERVER] groups, where xxxxx is the name of the application into which the server is embedded.

mysqld從[mysqld]和[server]組中讀取選項(xiàng)。 mysqld_safe從[mysqld]，[server]，[mysqld_safe]和[safe_mysqld]組中讀取選項(xiàng)。 mysql.server從[mysqld]和[mysql.server]組中讀取選項(xiàng)。

嵌入式MySQL服務(wù)器通常從[server]，[embedded]和[xxxxx_SERVER]組中讀取選項(xiàng)，其中xxxxx是嵌入服務(wù)器的應(yīng)用程序的名稱。

/tupian/20230522/server-options.html#option_mysqld_defaults-group-suffix

Read not only the usual option groups, but also groups with the usual names and a suffix of str. For example, mysqld normally reads the [mysqld] group. If the --defaults-group-suffix=_other option is given, mysqld also reads the [mysqld_other] group.

不僅要讀取常用選項(xiàng)組，還要讀取通常名稱和后綴str的組。 例如，mysqld通常讀取[mysqld]組。 如果給出了--defaults-group-suffix = _other選項(xiàng)，mysqld也會(huì)讀取[mysqld_other]組。

分享名稱：my.cnf文件關(guān)于組選項(xiàng)的總結(jié)-創(chuàng)新互聯(lián)
標(biāo)題路徑：http://jinyejixie.com/article46/piieg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供Google、建站公司、關(guān)鍵詞優(yōu)化、電子商務(wù)、響應(yīng)式網(wǎng)站、網(wǎng)站排名

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)