mysql56-server: what is basedir? and where put my.cnf?

[Bradley Giesbrecht]

On Sep 15, 2014, at 12:22 PM, Murray Eisenberg <murrayeisenberg at gmail.com> wrote:

> (1) Right now for my installation of mysql56-server (and mysql56), I've put all my configuration settings in 
> 
>    /opt/local/etc/mysql56/my.cnf
> 
>    (a) With _no_ setting there for basedir, mysql server and client work just fine.
> 
>    (b) If I use "basedir =  /opt/local/lib/mysql56", then the server won't start. I get error:
>        "The server quit without updating PID file (/opt/local/var/db/mysql56/Blackstone.local.pid)."
> 
>    So what should the value of basedir be, in other words, for the MacPorts port just what _is_ the "installation     
>    directory" (as the MySQL docs say the value should be)??

There is _no_ need to set these options. The only non-default option set by MacPorts is in /opt/local/etc/mysql56/macports-default.cnf and this can be easily removed by simply removing/commenting the include line in the default cat /opt/local/etc/mysql56/my.cnf file.

It is probably best to start with an empty /opt/local/etc/mysql56/my.cnf options file and add settings as you discover a need for them.
An "empty" /opt/local/etc/mysql56/my.cnf should "just work".

If you elect to override mysql defaults please refer to the mysql documentation:
http://dev.mysql.com/doc/refman/5.6/en/server-options.html
http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html

> (2) For the MacPorts version of mysql, what is the recommended or preferred location for my.cnf?  
> 
>    Possibilities are:
> 
>        /opt/local/etc/mysql56/my.cnf    (which I'm using)
This is the default my.cnf file.

>        /opt/local/etc/my.cnf
Please remove or rename this file.

>        /private/etc/my.cnf
Please remove or rename this file.



Regards,
Bradley Giesbrecht (pixilla)

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 455 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <https://lists.macosforge.org/pipermail/macports-users/attachments/20140916/ce6b2f66/attachment.sig>