MySQL config file location - redhat linux server

Question

What is the default location for the MySQL configuration file on a redhat linux box?

score 58 · Answer 1 · answered Dec 04 '08 at 18:28

58

Just found it, it is /etc/my.cnf

answered Dec 04 '08 at 18:28

user42931

1,135
2
10
12

score 48 · Answer 2 · answered Apr 03 '12 at 21:26

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

For me `/usr/libexec/mysqld --help --verbose` worked instead of `mysqld --help --verbose` — Andron, Apr 01 '13 at 15:36
@Andron yes if the path to executable daemon is not in the ENV PATH, you will have to specify the absolute path to the daemon executable. — ThinkingMonkey, Apr 01 '13 at 18:21

score 21 · Answer 3 · edited Dec 26 '11 at 12:20

21

it is located at /etc/mysql/my.cnf

edited Dec 26 '11 at 12:20

Adrien Plisson

22,486
6
42
73

answered Dec 26 '11 at 12:05

Nugatu

219
2
2

3

This is default on debian based distros, but not valid for RedHat. – Kaii Jun 29 '18 at 11:38

score 8 · Answer 4 · answered Oct 04 '15 at 08:56

All of them seemed good candidates:

/etc/my.cnf
/etc/mysql/my.cnf
/var/lib/mysql/my.cnf
...

in many cases you could simply check system process list using ps:

server ~ # ps ax | grep '[m]ysqld'

Output

10801 ?        Ssl    0:27 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock

Or

which mysqld
/usr/sbin/mysqld

Then

/usr/sbin/mysqld --verbose --help | grep -A 1 "Default options"

/etc/mysql/my.cnf ~/.my.cnf /usr/etc/my.cnf

score 5 · Answer 5 · edited Jun 29 '18 at 11:37

5

On RH systems, MySQL configuration file is located under /etc/my.cnf by default.

edited Jun 29 '18 at 11:37

Kaii

20,122
3
38
60

answered Apr 16 '12 at 00:03

Sasha

415
6
5

score 5 · Answer 6 · edited Jul 17 '15 at 09:00

5

Default options are read from the following files in the given order:

/etc/mysql/my.cnf 
/etc/my.cnf 
~/.my.cnf

edited Jul 17 '15 at 09:00

Toby Allen

10,997
11
73
124

answered Jul 16 '15 at 13:42

score 3 · Answer 7 · answered Aug 26 '16 at 04:42

3

In the docker containers(centos based images) it is located at

/etc/mysql/my.cnf

answered Aug 26 '16 at 04:42

Jauyzed

512
4
18

score 1 · Answer 8 · answered Apr 30 '16 at 15:01

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

MySQL config file location - redhat linux server

8 Answers8