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

Murray Eisenberg murrayeisenberg at gmail.com
Mon Sep 15 12:22:10 PDT 2014


(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)??

(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


---
Murray Eisenberg		murrayeisenberg at gmail.com
503 King Farm Blvd #101		Home (240)-246-7240
Rockville, MD 20850-6667	Mobile (413)-427-5334







More information about the macports-users mailing list