can't start mysql56 after move datadir

Murray Eisenberg murrayeisenberg at
Fri Feb 13 09:34:54 PST 2015

The Finder Get Info Sharing & Permissions doesn't seem to allow adding x permission to anything, just read only, write only, or read & write. In any case, user _mysql does not appear among the users to add that way.

The chmod man entry for ACL manipulations is hard to penetrate. 

With my mysql datadir in


and that matador already owned my _mysql, is the following what I should do?

   chmod +a "_mysql allow execute" /Volumes/MacHD/Users/thisuser/Databases/mysql
   chmod +a "_mysql allow execute" /Volumes/MacHD/Users/thisuser/Databases

(/Volumes/MacHD/Users/thisuser already has +x permission for all).
> On 13 Feb2015, at 12:14 PM, Brandon Allbery <allbery.b at> wrote:
> On Fri, Feb 13, 2015 at 12:05 PM, Murray Eisenberg <murrayeisenberg at> wrote:
> Isn't there some safer way to be able to use mysql with a datadir in a non-default location (after specifying it in my.cnf, of course)?
> You can use ACLs to only grant that permission to the _mysql user (see ACL MANIPULATION OPTIONS in `man chmod`, or use Get Info in the Finder and see the "Sharing and Permissions" section at the bottom of the info pane). But in general granting directory search permission is common and not considered to be a significant security issue. In particular, by default everything up to /Volumes/MacHD/Users/$USER will generally have a+x.
> pyanfar:4326 Z$ sh -c 'oIFS="$IFS"; IFS=/; set -- $(pwd); p=; for d; do IFS="$oIFS"; p="$p/$d"; ls -ld "$p"; done'
> drwxr-xr-x  34 root  admin  1224 Feb 12 07:17 /
> drwxr-xr-x  6 root  admin  204 Aug 29 11:43 //Users
> drwxr-xr-x+ 61 allbery  staff  2074 Feb 13 12:06 //Users/allbery
> drwx------@ 57 allbery  staff  1938 Feb 13 11:19 //Users/allbery/Library
> drwx------+ 187 allbery  staff  6358 Feb 13 12:12 //Users/allbery/Library/Preferences
> -- 
> brandon s allbery kf8nh                               sine nomine associates
> allbery.b at                                  ballbery at
> unix, openafs, kerberos, infrastructure, xmonad

Murray Eisenberg		murrayeisenberg at
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