MySQL当前使用配置文件(my.cnf)的路径查询方法

如果不知道当前使用的配置文件的路径,可以尝试下面的操作:

which mysqld

/usr/local/mysql/bin/mysqld

/usr/local/mysql/bin/mysqld --verbose --help |grep -A 1 'Default options'

2016-06-02 16:49:39 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.25-log) starting as process 8253 ...
2016-06-02 16:49:41 8253 [Note] Plugin 'FEDERATED' is disabled.
Default options are read from the following files in the given

order: 默认的选项是按照给定的顺序读取从以下文件:

/etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf
联系我们

邮箱 626512443@qq.com
电话 18611320371(微信)
QQ群 235681453

Copyright © 2015-2024

备案号:京ICP备15003423号-3