my.cnf file missing and cannot be found at any directory

Question

I recently removed mysql 5.1 an installed mysql 5.6 on my CENTOS 6 x86 OS. When I try to look for the my.cnf file it is missing from these directories:

mysqld --verbose --help | grep -A 1 "Default options"

=

/etc/my.cnf, /etc/mysql/my.cnf, and ~/.my.cnf.

Now I went to my mysql home directory which is /var/lib/mysql to find the .cnf file but all I found was auto.cnf.

Does anyone have any ideas? Could I just download a my.cnf file and place it in one of those directories?

score 4 · Accepted Answer · answered Sep 21 '12 at 11:38

4

sudo updatedb && locate my.cnf

answered Sep 21 '12 at 11:38

jacktrade

3,125
2
36
50

What woud be the CENTOS OS way of doing it? :) `yum updatedb && locate my.cnf`? I tried `locate my.cnf` but it says `/var/lib/mlocate/mlocate.db no such file or dir`. – Sep 21 '12 at 11:40
yum is to manage (install, remove) software, try to locate the file with root user – jacktrade Sep 21 '12 at 15:03

score 0 · Answer 2 · answered Jun 28 '14 at 13:11

0

if you are having trouble with locate

as root: find / -name my.cnf

how did you install mysql? with yum?

answered Jun 28 '14 at 13:11

devBorg

224
1
5

2

A `-type f` would speed things up dramatically. – Markus W Mahlberg Jun 28 '14 at 14:42

score 0 · Answer 3 · answered Jul 18 '14 at 20:55

0

I am running Centos 6.5. When I went to install MySQL-server.X86_64 5.6.12-2.el6, it put my.cnf in /usr. /usr/my.cnf ? What the hell is my.cnf doing in /usr ?

I found it using find / -iname my.cnf -print

answered Jul 18 '14 at 20:55

Jeff Silverman

692
1
8
15

score 0 · Answer 4 · answered Oct 16 '17 at 05:37

0

The location is changed to /mysql.d, and the filename is changed to something like mysqld.cnf. Also, there's a similar question somewhere (maybe duplicate here or there).

answered Oct 16 '17 at 05:37

Wolfpack'08

3,982
11
46
78

my.cnf file missing and cannot be found at any directory

4 Answers4