<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=""><div class="">Environment: macOS 10.14, MacPorts 2.5.4</div><div class=""><br class=""></div><div class="">Port: <span style="font-family: Menlo; font-size: 12px;" class="">mysql57-server @5.7.17_0 (active)</span></div><div class=""><br class=""></div>At my wits end as to why suddenly mysqld won’t start.<div class=""><br class=""></div><div class="">Command:</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="">sudo /opt/local/share/mysql57/support-files/mysql.server start</span></div><div class=""><font face="Menlo" class=""><span style="font-size: 12px;" class=""><br class=""></span></font></div><div class="">Response:</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="">Starting MySQL</span><div style="margin: 0px; font-stretch: normal; font-size: 12px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> . ERROR! The server quit without updating PID file (/Users/me/Databases/mysql/data/mysql.pid).</span></div><div style="margin: 0px; font-stretch: normal; font-size: 12px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div style="margin: 0px; font-stretch: normal; font-size: 12px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><span style="font-family: Helvetica; font-size: 14px;" class="">The active (non-commented) lines of </span>/opt/local/etc/mysql57/my.cnf <span style="font-family: Helvetica; font-size: 14px;" class="">are:</span></span></div><div style="margin: 0px; font-stretch: normal; font-size: 12px; line-height: normal; font-family: Menlo;" class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures;" class=""><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>!include /opt/local/etc/mysql57/macports-default.cnf</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>[mysqld]</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>datadir = /Users/me/Databases/mysql/data</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>port = 3306</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>socket = /opt/local/var/run/mysql57/mysqld.sock</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>pid-file = /opt/local/var/run/mysqld/mysqld.pid</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES </div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>[client]</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>socket = /opt/local/var/run/mysql57/mysqld.sock</div></span></div><div style="margin: 0px; font-stretch: normal; font-size: 12px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><span style="font-family: Helvetica; font-size: 14px;" class=""><br class=""></span></span></div><div style="margin: 0px; font-stretch: normal; font-size: 12px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><span style="font-family: Helvetica; font-size: 14px;" class="">Permissions:</span></span></div><div style="margin: 0px; font-stretch: normal; font-size: 12px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><span style="font-family: Helvetica; font-size: 14px;" class=""><br class=""></span></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span><span style="font-family: Menlo; font-size: 12px;" class="">ls -ld</span><span style="font-family: Menlo; font-size: 12px;" class=""> </span><span style="font-family: Menlo; font-size: 12px;" class="">/opt/local/var/run/mysqld</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><div style="font-family: Menlo; font-size: 12px; margin: 0px; font-stretch: normal; line-height: normal;" class=""><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">drwxr-xr-x 2 _mysql _mysql 64 Oct 24 16:08 /opt/local/var/run/mysqld</span></div></div><div style="font-family: Menlo; font-size: 12px; margin: 0px; font-stretch: normal; line-height: normal;" class=""><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> ls -ld /opt/local/var/run/mysql57</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">drwxr-xr-x 4 _mysql _mysql 128 Oct 24 13:10 /opt/local/var/run/mysql57</span></div></div><div style="font-family: Menlo; font-size: 12px; margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class="">I had used: <span style="font-family: Menlo; font-size: 12px;" class="">sudo chown -R mysql:mysql /opt/local/var/run/mysqld</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-family: Menlo; font-size: 12px;" class=""><br class=""></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class="">What’s wrong?</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class="">Note: So far as I’m aware, I had not changed anything recently except for normal “sudo port sync” and "sudo port upgrade outdated”.</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><br class=""></div></div><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>