<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Normally the socket file is created under /tmp/<div class="">edit /opt/local/etc/mysql57/my.cnf and do the following:</div><div class=""><br class=""></div><div class="">Change:</div><div class=""><br class=""></div><div class=""><blockquote type="cite" class=""><div class="WordSection1" style="page: WordSection1;"><div class=""><div class=""><blockquote class="" type="cite" style="margin-top: 5pt; margin-bottom: 5pt;"><div class=""><div class=""><div class="" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span lang="EN-US" class="" style="font-family: Verdana, sans-serif;">socket = /opt/local/var/run/mysql57/mysqld.sock</span></div></div></div></blockquote></div></div></div></blockquote><div class=""><br class=""></div>to</div><div class=""><br class=""></div><div class=""><blockquote type="cite" class=""><div class="WordSection1" style="page: WordSection1;"><div class=""><div class=""><blockquote class="" type="cite" style="margin-top: 5pt; margin-bottom: 5pt;"><div class=""><div class=""><div class="" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span lang="EN-US" class="" style="font-family: Verdana, sans-serif;">socket = /tmp/mysqld.sock</span></div></div></div></blockquote></div></div></div></blockquote><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 27, 2020, at 11:23 AM, John Korchok <<a href="mailto:jkorchok@gmail.com" class="">jkorchok@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="WordSection1" style="page: WordSection1; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; 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;"><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">Hi John,<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">As mentioned in my post, I can open mysql -u root -p with no problem. MySQL is running, it's just the sock file that is not being created.<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">John Korchok<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class=""><o:p class=""> </o:p></span></div><div class=""><div style="border-style: solid none none; border-top-width: 1pt; border-top-color: rgb(225, 225, 225); padding: 3pt 0in 0in;" class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span lang="EN-US" class="">From:</span></b><span lang="EN-US" class=""><span class="Apple-converted-space"> </span>John Chung <<a href="mailto:jchung@nyquest.com" class="">jchung@nyquest.com</a>><span class="Apple-converted-space"> </span><br class=""><b class="">Sent:</b><span class="Apple-converted-space"> </span>Thursday, March 26, 2020 9:15 PM<br class=""><b class="">To:</b><span class="Apple-converted-space"> </span>John Korchok <<a href="mailto:jkorchok@gmail.com" class="">jkorchok@gmail.com</a>><br class=""><b class="">Cc:</b><span class="Apple-converted-space"> </span><a href="mailto:macports-users@lists.macports.org" class="">macports-users@lists.macports.org</a><br class=""><b class="">Subject:</b><span class="Apple-converted-space"> </span>Re: Misbehaving mysql57-server<o:p class=""></o:p></span></div></div></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">John that looks completely ..<o:p class=""></o:p></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">What happens when you try connect ?<o:p class=""></o:p></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">mysql -u root -p<o:p class=""></o:p></div><div class=""><div class=""><div class=""><div class=""><div class=""><div class=""><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="" class="">________________________________<o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="font-size: 13.5pt;" class="">John T. Chung</span></b><span style="" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="" class="">Technical Architect<o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="" class=""><o:p class=""> </o:p></span></div></div><div class=""><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="color: rgb(226, 57, 153);" class="">+1.419.464.9637 | Office</span></b><span style="" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="color: rgb(226, 57, 153);" class="">+1.419.973.9072 | Mobile</span></b><span style="" class=""><o:p class=""></o:p></span></div></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="" class=""><o:p class=""> </o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 17.5pt;" class="">Nyquest Consulting </span><span style="" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 17.5pt;" class=""><a href="http://www.nyquest.com/" style="color: blue; text-decoration: underline;" class="">http://www.nyquest.com</a></span><span style="" class=""><o:p class=""></o:p></span></div></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="" class=""><o:p class=""> </o:p></span></div></div></div></div></div></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><br class=""><br class=""><o:p class=""></o:p></div><blockquote style="margin-top: 5pt; margin-bottom: 5pt;" class="" type="cite"><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">On Mar 26, 2020, at 7:42 PM, John Korchok <<a href="mailto:jkorchok@gmail.com" style="color: blue; text-decoration: underline;" class="">jkorchok@gmail.com</a>> wrote:<o:p class=""></o:p></div></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div class=""><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">Hi all,</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class=""> </span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">This is my second installation of MySQL 5.7. I've had more problems with this version than any previous one. The mysql57-server port is installed.</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class=""> </span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">MySQL is running, I can run mysql -u root -p with no problem, but mysqld.sock is not created in /opt/local/var/run/mysql57. A mysqld.sock.lock file is _<i class="">is</i>_ created in that folder.</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class=""> </span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">That folder is owned by _mysql, permissions were set to 755, but even 777 makes no difference.</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class=""> </span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">/opt/local/etc/mysql57/my.cnf reads:</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class=""> </span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class=""># Use default MacPorts settings</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">!include /opt/local/etc/mysql57/macports-default.cnf</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class=""> </span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">[client]</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">user = mysql</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">host = localhost</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">password = "blahblahblah"</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">port = 3306</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">socket = /opt/local/var/run/mysql57/mysqld.sock</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class=""> </span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">[mysqld]</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">log-error = /opt/local/var/log/mysql57/mysql-error.log</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">socket = /opt/local/var/run/mysql57/mysqld.sock</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class=""> </span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">The error log just shows a normal startup, no issues. What else can I check or configure to make this work?</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class=""> </span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-family: Verdana, sans-serif;" class="">John Korchok</span><span style="font-family: Verdana, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 10.5pt; font-family: Helvetica, sans-serif;" class=""><o:p class=""> </o:p></span></div><table class="MsoNormalTable" border="1" cellpadding="0" style="border-style: solid none none; border-top-width: 1pt; border-top-color: rgb(211, 212, 222);"><tbody class=""><tr class=""><td width="55" style="width: 41.25pt; border: none; padding: 9.75pt 0.75pt 0.75pt;" class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon" target="_blank" style="color: blue; text-decoration: underline;" class=""><span style="text-decoration: none;" class=""><img border="0" width="46" height="29" id="_x0000_i1025" src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" style="width: 0.4791in; height: 0.302in;" class=""></span></a><o:p class=""></o:p></div></td><td width="470" style="width: 352.5pt; border: none; padding: 9pt 0.75pt 0.75pt;" class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; line-height: 13.5pt;" class=""><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(65, 66, 78);" class="">Virus-free.<span class="apple-converted-space"> </span><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link" target="_blank" style="color: blue; text-decoration: underline;" class=""><span style="color: rgb(68, 83, 234);" class="">www.avast.com</span></a></span></div></td></tr></tbody></table></div></div></blockquote></div></div></div></div></blockquote></div><br class=""></div></body></html>