PHP Developers Network

A community of PHP developers offering assistance, advice, discussion, and friendship.
 
Loading
It is currently Tue Dec 18, 2018 9:31 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 7 posts ] 
Author Message
PostPosted: Fri May 29, 2015 11:11 am 
Offline
Forum Contributor

Joined: Thu Apr 16, 2015 7:55 am
Posts: 110
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.


Top
 Profile  
 
PostPosted: Fri May 29, 2015 11:30 am 
Offline
Moderator
User avatar

Joined: Tue Nov 09, 2010 3:39 pm
Posts: 6424
Location: Montreal, Canada
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?

Syntax: [ Download ] [ Hide ]
[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

_________________
Supported PHP versions No longer supported versions


Top
 Profile  
 
PostPosted: Fri May 29, 2015 11:37 am 
Offline
Forum Contributor

Joined: Thu Apr 16, 2015 7:55 am
Posts: 110
Celauran wrote:
You sure?

Syntax: [ Download ] [ Hide ]
[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


It's strange. :|
Syntax: [ Download ] [ Hide ]
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
 


Syntax: [ Download ] [ Hide ]
 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
 


Top
 Profile  
 
PostPosted: Fri May 29, 2015 11:41 am 
Offline
Forum Contributor

Joined: Thu Apr 16, 2015 7:55 am
Posts: 110
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:


Top
 Profile  
 
PostPosted: Fri May 29, 2015 12:20 pm 
Offline
Forum Contributor

Joined: Thu Apr 16, 2015 7:55 am
Posts: 110
Hi Celauran,

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


Top
 Profile  
 
PostPosted: Fri May 29, 2015 1:32 pm 
Offline
Moderator
User avatar

Joined: Tue Nov 09, 2010 3:39 pm
Posts: 6424
Location: Montreal, Canada
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?

_________________
Supported PHP versions No longer supported versions


Top
 Profile  
 
PostPosted: Fri May 29, 2015 1:52 pm 
Offline
Forum Contributor

Joined: Thu Apr 16, 2015 7:55 am
Posts: 110
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: Exabot [Bot] and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group