about my.cnf on MAC OS X

[SpreadTooThin]

The installation package of MySQL Community Server doesn't create a my.cnf file.

1)why?

2)searching around it seems it should have been created in /etc but I see some installation where the only my.cnf file I can find is in /private/etc and other in the installation directory..

So which directory is the correct directory to create my.cnf file?

3) There are several sample my.cnf files in the mysql installation directory... How should I select the appropriate one?

[Peter H. Coffin]

On Mon, 16 Sep 2013 13:46:01 -0700 (PDT), SpreadTooThin wrote:

> The installation package of MySQL Community Server doesn't create a
> my.cnf file.
>
> 1)why?

Because it doesn't know how you're going to use it. How could it pick
appropriate values without knowing that?

Running without my.cnf will just use the built-in defaults, which are
sub-optimal for many things but functional enough to get you to the
point of realizing that you need to change something.

> 2)searching around it seems it should have been created in /etc but
> I see some installation where the only my.cnf file I can find is in
> /private/etc and other in the installation directory..
>
> So which directory is the correct directory to create my.cnf file?

/etc/

> 3) There are several sample my.cnf files in the mysql installation
> directory... How should I select the appropriate one?

If you don't know, research what you want to change and create your own.
Read the samples, sure, but don't just copy one without knowing what
you're changing.

--
74. When I create a multimedia presentation of my plan designed so that
my five-year-old advisor can easily understand the details, I will
not label the disk "Project Overlord" and leave it lying on top of
my desk. --Peter Anspach's list of things to do as an Evil Overlord