<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Such searches give different instructions on what permissions to give the mysql datadir !<div class=""><br class=""></div><div class="">If the datadir is </div><div class=""><br class=""></div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span><span style="font-family: Menlo; font-size: 12px;" class="">/Users/me/Databases/mysql/data</span></div><div class=""><font face="Menlo" class=""><span style="font-size: 12px;" class=""><br class=""></span></font></div><div class="">(and my.cnf includes "datadir = /Users/murray/Databases/mysql/data”, of course),</div><div class="">then who should be the owner and what should the permissions be on that directory?</div><div class=""><br class=""></div><div class="">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.</div><div class=""><br class=""></div><div class="">Exactly what chown and chmod commands should be used on the datadir? (Even the official MySQL docs are incomplete on this.)<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On 25 Oct2018, at 9:37 AM, Ryan Schmidt <<a href="mailto:ryandesign@macports.org" class="">ryandesign@macports.org</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class=""><br class=""><br class="">On Oct 24, 2018, at 15:25, Murray Eisenberg wrote:<br class=""><br class=""><blockquote type="cite" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>Starting MySQL<br class=""> . ERROR! The server quit without updating PID file (/Users/me/Databases/mysql/data/mysql.pid).<br class=""><br class=""></blockquote><br class="">This is probably not a MacPorts-specific problem; you should search the Internet. I did, and one result suggested that this error can occur if the server is already running. Another suggested looking at the permissions of the directory.<br class=""><br class="">It is curious that it is trying to update a pid file in your data directory when your cnf file appear to have told it to put it somewhere else, but I'm not sure if that's relevant. It might be, if the data directory and the place where the cnf file says to put the pid file have different permissions.<br class=""><br class=""><br class=""></div></div></blockquote></div><br class=""><div class="">
---<br class="">Murray Eisenberg<span class="Apple-tab-span" style="white-space: pre;"> </span><a href="mailto:murrayeisenberg@gmail.com" class="">murrayeisenberg@gmail.com</a><br class="">503 King Farm Blvd #101<span class="Apple-tab-span" style="white-space: pre;"> </span>Home (240)-246-7240<br class="">Rockville, MD 20850-6667<span class="Apple-tab-span" style="white-space: pre;"> </span>Mobile (413)-427-5334<br class=""><br class="">
</div>
<br class=""></div></body></html>