(Defaults to on; use --skip-auto-rehash to disable.)
-A, --no-auto-rehash
--
(Defaults to on; use --skip-line-numbers to disable.)
-L, --skip-line-numbers
--
(Defaults to on; use --skip-column-names to disable.)
-N, --skip-column-names
--
(Defaults to on; use --skip-reconnect to disable.)
-s, --silent Be more silent. Print results with a tab as separator,
--
--default-auth=name Default authentication client-side plugin to use.
--binary-mode By default, ASCII '\0' is disallowed and '\r\n' is
--
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
The information you want can be found by running
mysql --help
or
mysqld --help --verbose
I tried this :
mysql --help | grep Default -A 1
And the output:
(Defaults to on; use --skip-auto-rehash to disable.)
-A, --no-auto-rehash
--
(Defaults to on; use --skip-line-numbers to disable.)
-L, --skip-line-numbers
--
(Defaults to on; use --skip-column-names to disable.)
-N, --skip-column-names
--
(Defaults to on; use --skip-reconnect to disable.)
-s, --silent Be more silent. Print results with a tab as separator,
--
--default-auth=name Default authentication client-side plugin to use.
--binary-mode By default, ASCII '\0' is disallowed and '\r\n' is
--
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
MariaDB programs look for option files in a set of
locations which depend on the deployment platform.
[...] For information about these locations, do:
'my_print_defaults --help' and see what is printed under
"Default options are read from the following files in the given order:"
More information at: http://dev.mysql.com/doc/mysql/en/option-files.html
From the header of '/etc/mysql/my.cnf':
MariaDB programs look for option files in a set of
locations which depend on the deployment platform.
[...] For information about these locations, do:
'my_print_defaults --help' and see what is printed under
"Default options are read from the following files in the given order:"
More information at: http://dev.mysql.com/doc/mysql/en/option-files.html
发布评论
评论（8）
刚刚找到了，是/etc/my.cnf
Just found it, it is /etc/my.cnf
您想要的信息可以通过运行找到
，或者
我尝试过：
输出：
The information you want can be found by running
or
I tried this :
And the output:
它位于
/etc/mysql/my.cnfit is located at
/etc/mysql/my.cnf所有这些似乎都是不错的候选者：
检查系统进程列表
在许多情况下，您可以简单地使用 ps: Output
Or
then
All of them seemed good candidates:
in many cases you could simply check system process list using ps:
Output
Or
Then
默认选项按给定顺序从以下文件中读取：
Default options are read from the following files in the given order:
在 RH 系统上，MySQL 配置文件默认位于 /etc/my.cnf 下。
On RH systems, MySQL configuration file is located under /etc/my.cnf by default.
在 docker 容器（基于 centos 的镜像）中，它位于
/etc/mysql/my.cnf
In the docker containers(centos based images) it is located at
/etc/mysql/my.cnf
从“/etc/mysql/my.cnf”的标头：
From the header of '/etc/mysql/my.cnf':