Where is MySQL 5.7 my.cnf file?

Question

In Ubuntu I had my.cnf file of MySQL 5.6 in /etc/my.cnf. But I can't find the same file of MySQL 5.7. From where can I find that?

I did a find in entire / (root). But I couldn't find it anywhere. Any clues?

I'm trying to set max_connections value.

You have to create it. If it doesn't exist, default settings are used for everything. — Barmar, Jul 20 '16 at 21:11
The doc is a bit clear on it. http://dev.mysql.com/doc/refman/5.7/en/option-files.html . see the comment at the bottom from Tim MAHER-DE TROYER — Drew, Jul 20 '16 at 21:12
Does this answer your question? [How do I find the MySQL my.cnf location](https://stackoverflow.com/questions/2482234/how-do-i-find-the-mysql-my-cnf-location) — Channa, Jun 05 '21 at 07:19

score 34 · Answer 1 · answered Mar 03 '17 at 03:11

34

In MySQL 5.7, the default cnf is at:

/etc/mysql/mysql.conf.d/mysqld.cnf

answered Mar 03 '17 at 03:11

neobie

2,847
5
27
31

Just a note for people trying to `set lower_case_table_names=1` (or 0, 2), type in terminal */etc/home$ mysqld --help --verbose* and search for my.cnf, under **default options** look for places where my.cnf is supposed to be there and then check if actually they exist in file system, if any location is missing this file, copy the contents of mysqld.cnf and paste it in a new file named my.cnf (.my.cnf for ~/ dir). – Hashmatullah Noorzai Apr 28 '20 at 19:26
1

The file is actually located at `/etc/my.cnf` or `/etc/mysql/my.cnf` It has been renamed from mysqld.cnf to just my.cnf in 5.7 https://dev.mysql.com/doc/refman/5.7/en/option-files.html – Ode Feb 10 '23 at 20:55

score 14 · Accepted Answer · answered Jul 21 '16 at 05:29

mysql --help printed below.

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf 

The following groups are read: mysql client
The following options may be given as the first argument:
--print-defaults        Print the program argument list and exit.
--no-defaults           Don't read default options from any option file,
                        except for login file.
--defaults-file=#       Only read default options from the given file #.
--defaults-extra-file=# Read this file after the global files are read.
--defaults-group-suffix=#
                        Also read groups with concat(group, suffix)
--login-path=#          Read this path from the login file.

Where is MySQL 5.7 my.cnf file?

2 Answers2

Linked