<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="">John a couple more questions<div class=""><br class=""></div><div class="">1. How are you starting mysql ?</div><div class="">I am not using the macports version of mysql 5.7, as I compiled my version from source, but I start it with the following:</div><div class=""><br class=""></div><div class=""><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">sh-3.2# /usr/local/mysql/bin/mysqld_safe --user=_mysql & </span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">[1] 581</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">sh-3.2# 2020-03-30T03:04:30.6NZ mysqld_safe Logging to ‘/var/log/mysql.err'.</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-30T03:04:30.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data</span></div></div><div class=""><br class=""></div><div class="">2. In my my.cnf, I have the following:</div><div class=""><br class=""></div><div class=""><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">[mysqld_safe]</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">log-error=/var/mysql/mysql.log</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">pid-file=/var/mysql/mysql.pid</span></div><div style="margin: 0px; font-stretch: normal; 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; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">do you have a mysqld_safe block?</span></div><div style="margin: 0px; font-stretch: normal; 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; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div class="">
<div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div><div class=""><div class="">________________________________</div><div class=""><font size="4" class=""><b class="">John T. Chung</b></font></div><div class="">Technical Architect</div><div class=""><br class=""></div><div class=""><div class=""><b class=""><font color="#e23999" class="">+1.419.464.9637 | Office</font></b></div><div class=""><b class=""><font color="#e23999" class="">+1.419.973.9072 | Mobile</font></b></div></div><div class=""><br class=""></div><div class=""><span class="" style="font-size: 23px;">Nyquest Consulting </span></div><div class=""><span class="" style="font-size: 23px;"><a href="http://www.nyquest.com/" class="">http://www.nyquest.com</a></span></div></div><div class=""><br class=""></div></div></div></div></div><br class="Apple-interchange-newline">
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">On Mar 29, 2020, at 11:05 PM, Bill Cole <<a href="mailto:macportsusers-20171215@billmail.scconsult.com" class="">macportsusers-20171215@billmail.scconsult.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">On 29 Mar 2020, at 19:58, John Korchok wrote:<br class=""><br class=""><blockquote type="cite" class="">With the addition of sudo, I get:<br class=""><br class="">COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME<br class="">mysqld 79 _mysql 10u unix 0x40bdd8b3f53719a7 0t0 /opt/local/var/run/mysql56/mysqld.sock<br class=""><br class="">but there is still no sock file at that location. As I mentioned earlier, the mysql-error log does show the creation of the sock file on the last line after restarting.<br class=""><br class="">Is there a process that might destroy it after it's created?<br class=""></blockquote><br class="">That could be p[art of some convoluted explanation, but I think the explanation is MUCH simpler.<br class=""><br class="">Are you relying on the Finder to look in /opt/local/var/run/mysql56/? Don't. It will not show you everything. Use 'ls' instead.<br class=""><br class=""><br class="">-- <br class="">Bill Cole<br class=""><a href="mailto:bill@scconsult.com" class="">bill@scconsult.com</a> or <a href="mailto:billcole@apache.org" class="">billcole@apache.org</a><br class="">(AKA @grumpybozo and many *@billmail.scconsult.com addresses)<br class="">Not For Hire (currently)<br class=""></div></div></blockquote></div><br class=""></div></body></html>