On Oct 25, 2018, at 10:34, Murray Eisenberg wrote:
> Such searches give different instructions on what permissions to give the > mysql datadir ! > > If the datadir is > > /Users/me/Databases/mysql/data > > (and my.cnf includes "datadir = /Users/murray/Databases/mysql/data”, of > course), > then who should be the owner and what should the permissions be on that > directory? > > I see all sorts of answers to that, from various mysql versions, or of > varying vintage, or on various platforms, or on native /usr/… vs. /opt/.. > (latter being MacPorts) configurations — which is leading me to total > confusion. > > Exactly what chown and chmod commands should be used on the datadir? (Even > the official MySQL docs are incomplete on this.) I would imagine that the data directory should be owned by the user account that runs the MySQL server. Assuming you are using the mysql57-server port and are using "sudo port load" to start that server, and you are on Mac OS X 10.5 or later, the name of the user account is _mysql. It has been a long time since I've dealt with MySQL. You might check the wiki page for guidance: https://trac.macports.org/wiki/howto/MySQL
