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

[Ryan Schmidt]

On Sep 15, 2014, at 2:22 PM, Murray Eisenberg 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)??
> 

If it works fine without setting basedir, then don't set it. I don't recall having ever set that value.

> (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)
>        /opt/local/etc/my.cnf        
>        /private/etc/my.cnf

Any location you like that MySQL supports.