Page 1 of 1

which .cnf file is correct?

Posted: Fri May 29, 2015 11:11 am
by publicGenome
Hi Members,
I'm working on mac 0sx10.9, installed mysql with homebrew.

I do not have .cnf file at /etc
Upon digging some random thing, navigating to web pages, and checking out history of my commands, I found I've 2 .cnf files:

/usr/local/opt/mysql/my.cnf
and
/usr/local/Cellar/mysql/5.6.23/my.cnf


/usr/local/opt/mysql/my.cnf has datadir and socket mentioned.
same as /usr/local/Cellar/mysql/5.6.23/my.cnf

they both aren't linked. I did ls -shl and found nothing on them.

Now which one should I be keeping? Should I keep them both, or delete both, and create/copy them at /etc/my.cnf?

Thanks for your guidance.

Re: which .cnf file is correct?

Posted: Fri May 29, 2015 11:30 am
by Celauran
publicGenome wrote:Hi Members,
I'm working on mac 0sx10.9, installed mysql with homebrew.

I do not have .cnf file at /etc
Upon digging some random thing, navigating to web pages, and checking out history of my commands, I found I've 2 .cnf files:

/usr/local/opt/mysql/my.cnf
and
/usr/local/Cellar/mysql/5.6.23/my.cnf


/usr/local/opt/mysql/my.cnf has datadir and socket mentioned.
same as /usr/local/Cellar/mysql/5.6.23/my.cnf

they both aren't linked.
You sure?

[text][12:28 pm] [~]
$ ls -l /usr/local/opt | grep mysql
lrwxr-xr-x 1 username admin 22 26 May 14:48 mysql -> ../Cellar/mysql/5.6.24[/text]

Re: which .cnf file is correct?

Posted: Fri May 29, 2015 11:37 am
by publicGenome
Celauran wrote: You sure?

[text][12:28 pm] [~]
$ ls -l /usr/local/opt | grep mysql
lrwxr-xr-x 1 username admin 22 26 May 14:48 mysql -> ../Cellar/mysql/5.6.24[/text]
It's strange. :|
[text]
ls -shl /usr/local/Cellar/mysql/5.6.23/my.cnf
8 -rw-r--r-- 1 myusername admin 1.0K May 28 17:08 /usr/local/Cellar/mysql/5.6.23/my.cnf
[/text]

[text]
ls -shl /usr/local/opt/mysql/my.cnf
8 -rw-r--r-- 1 myusername admin 1.0K May 28 17:08 /usr/local/opt/mysql/my.cnf
[/text]

Re: which .cnf file is correct?

Posted: Fri May 29, 2015 11:41 am
by publicGenome
Alright. I made changes to sudo emacs /usr/local/Cellar/mysql/5.6.23/my.cnf
And they are visible to

less /usr/local/opt/mysql/my.cnf

I wonder why this isn't reflected in ls -shl :crazy:

Edit:

ls -shl /usr/local/opt/mysql
8 lrwxr-xr-x 1 username admin 22B Apr 8 13:52 /usr/local/opt/mysql -> ../Cellar/mysql/5.6.23

:drunk: :drunk:

Re: which .cnf file is correct?

Posted: Fri May 29, 2015 12:20 pm
by publicGenome
Hi Celauran,

Back to my question, should I make a new my.cnf at /etc?

Re: which .cnf file is correct?

Posted: Fri May 29, 2015 1:32 pm
by Celauran
No need. I've got almost exactly the same set up and it's working just fine. What issue(s) are you encountering that makes you think you'd need to?

Re: which .cnf file is correct?

Posted: Fri May 29, 2015 1:52 pm
by publicGenome
Hi Celauran,
Thanks for confirming.
I'm little concerned about the logs of mysql. I do not have any file where logs are being spit into for failures, queries run, and similar things.

Hence, I'm rambling.