<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="">John that looks completely ..<div class=""><br class=""></div><div class="">What happens when you try connect ?</div><div class=""><br class=""></div><div class="">mysql -u root -p<br class=""><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 26, 2020, at 7:42 PM, 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: Verdana, sans-serif;" class=""><span lang="EN-US" class="">Hi all,<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" 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.<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" 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.<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class="">That folder is owned by _mysql, permissions were set to 755, but even 777 makes no difference.<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class="">/opt/local/etc/mysql57/my.cnf reads:<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class=""># Use default MacPorts settings<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class="">!include /opt/local/etc/mysql57/macports-default.cnf<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class="">[client]<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class="">user = mysql<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class="">host = localhost<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class="">password = "blahblahblah"<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class="">port = 3306<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class="">socket = /opt/local/var/run/mysql57/mysqld.sock<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class="">[mysqld]<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class="">log-error = /opt/local/var/log/mysql57/mysql-error.log<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class="">socket = /opt/local/var/run/mysql57/mysqld.sock<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class="">The error log just shows a normal startup, no issues. What else can I check or configure to make this work?<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Verdana, sans-serif;" class=""><span lang="EN-US" class="">John Korchok<o:p class=""></o:p></span></div></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" style="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;" class=""><br class=""><table style="border-top-width: 1px; border-top-style: solid; border-top-color: rgb(211, 212, 222);" class=""><tbody class=""><tr class=""><td style="width: 55px; padding-top: 13px;" 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" class=""><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;" class=""></a></td><td style="width: 470px; padding-top: 12px; color: rgb(65, 66, 78); font-size: 13px; font-family: Arial, Helvetica, sans-serif; line-height: 18px;" 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: rgb(68, 83, 234);" class="">www.avast.com</a></td></tr></tbody></table></div></div></blockquote></div><br class=""></div></body></html>