<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"\@MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Verdana",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-CA link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>Hi John,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>Are you referring to a Macports installation? I'm following the steps in <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'><a href="https://trac.macports.org/wiki/howto/MySQL">https://trac.macports.org/wiki/howto/MySQL</a><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>Switching the location creates the same result. /private/tmp/mysqld.sock.lock is created, but not the sock file.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>John Korchok<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span lang=EN-US>From:</span></b><span lang=EN-US> John Chung <jchung@nyquest.com> <br><b>Sent:</b> Friday, March 27, 2020 11:38 AM<br><b>To:</b> John Korchok <jkorchok@gmail.com><br><b>Cc:</b> macports-users@lists.macports.org<br><b>Subject:</b> Re: Misbehaving mysql57-server<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Normally the socket file is created under /tmp/<o:p></o:p></p><div><p class=MsoNormal>edit /opt/local/etc/mysql57/my.cnf and do the following:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Change:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>socket = /opt/local/var/run/mysql57/mysqld.sock</span><o:p></o:p></p></div></div></div></blockquote></div></div></blockquote><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal>to<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>socket = /tmp/mysqld.sock</span><o:p></o:p></p></div></div></div></blockquote></div></div></blockquote><div><div><div><div><div><div><div><p class=MsoNormal><span style='color:black'>________________________________<o:p></o:p></span></p></div><div><p class=MsoNormal><b><span style='font-size:13.5pt;color:black'>John T. Chung</span></b><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:black'>Technical Architect<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div><div><div><p class=MsoNormal><b><span style='color:#E23999'>+1.419.464.9637 | Office</span></b><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><b><span style='color:#E23999'>+1.419.973.9072 | Mobile</span></b><span style='color:black'><o:p></o:p></span></p></div></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:17.5pt;color:black'>Nyquest Consulting </span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:17.5pt;color:black'><a href="http://www.nyquest.com/">http://www.nyquest.com</a></span><span style='color:black'><o:p></o:p></span></p></div></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div></div></div></div></div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><br><br><o:p></o:p></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>On Mar 27, 2020, at 11:23 AM, John Korchok <<a href="mailto:jkorchok@gmail.com">jkorchok@gmail.com</a>> wrote:<o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>Hi John,</span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>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.</span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>John Korchok</span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'> </span><o:p></o:p></p></div><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><div><p class=MsoNormal><b><span lang=EN-US>From:</span></b><span class=apple-converted-space><span lang=EN-US> </span></span><span lang=EN-US>John Chung <<a href="mailto:jchung@nyquest.com">jchung@nyquest.com</a>><span class=apple-converted-space> </span><br><b>Sent:</b><span class=apple-converted-space> </span>Thursday, March 26, 2020 9:15 PM<br><b>To:</b><span class=apple-converted-space> </span>John Korchok <<a href="mailto:jkorchok@gmail.com">jkorchok@gmail.com</a>><br><b>Cc:</b><span class=apple-converted-space> </span><a href="mailto:macports-users@lists.macports.org">macports-users@lists.macports.org</a><br><b>Subject:</b><span class=apple-converted-space> </span>Re: Misbehaving mysql57-server</span><o:p></o:p></p></div></div></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal>John that looks completely ..<o:p></o:p></p></div><div><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><div><p class=MsoNormal>What happens when you try connect ?<o:p></o:p></p></div></div><div><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><div><p class=MsoNormal>mysql -u root -p<o:p></o:p></p></div><div><div><div><div><div><div><div><div><p class=MsoNormal>________________________________<o:p></o:p></p></div></div><div><div><p class=MsoNormal><b><span style='font-size:13.5pt'>John T. Chung</span></b><o:p></o:p></p></div></div><div><div><p class=MsoNormal>Technical Architect<o:p></o:p></p></div></div><div><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><div><div><p class=MsoNormal><b><span style='color:#E23999'>+1.419.464.9637 | Office</span></b><o:p></o:p></p></div></div><div><div><p class=MsoNormal><b><span style='color:#E23999'>+1.419.973.9072 | Mobile</span></b><o:p></o:p></p></div></div></div><div><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-size:17.5pt'>Nyquest Consulting </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-size:17.5pt'><a href="http://www.nyquest.com/">http://www.nyquest.com</a></span><o:p></o:p></p></div></div></div><div><div><p class=MsoNormal> <o:p></o:p></p></div></div></div></div></div></div><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><div><p class=MsoNormal><br><br><br><o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><p class=MsoNormal>On Mar 26, 2020, at 7:42 PM, John Korchok <<a href="mailto:jkorchok@gmail.com">jkorchok@gmail.com</a>> wrote:<o:p></o:p></p></div></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>Hi all,</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>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><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>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>is</i>_ created in that folder.</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>That folder is owned by _mysql, permissions were set to 755, but even 777 makes no difference.</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>/opt/local/etc/mysql57/my.cnf reads:</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'># Use default MacPorts settings</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>!include /opt/local/etc/mysql57/macports-default.cnf</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>[client]</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>user = mysql</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>host = localhost</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>password = "blahblahblah"</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>port = 3306</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>socket = /opt/local/var/run/mysql57/mysqld.sock</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>[mysqld]</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>log-error = /opt/local/var/log/mysql57/mysql-error.log</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>socket = /opt/local/var/run/mysql57/mysqld.sock</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>The error log just shows a normal startup, no issues. What else can I check or configure to make this work?</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>John Korchok</span><o:p></o:p></p></div></div><div id=DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Helvetica",sans-serif'> </span><o:p></o:p></p></div><table class=MsoNormalTable border=1 cellpadding=0 style='border:none;border-top:solid #D3D4DE 1.0pt'><tr><td width=55 style='width:41.25pt;border:none;padding:9.75pt .75pt .75pt .75pt'><div><p class=MsoNormal><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"><span style='text-decoration:none'><img border=0 width=46 height=29 style='width:.4791in;height:.302in' id="_x0000_i1025" src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif"></span></a><o:p></o:p></p></div></td><td width=470 style='width:352.5pt;border:none;padding:9.0pt .75pt .75pt .75pt'><div><p class=MsoNormal style='line-height:13.5pt'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#41424E'>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"><span style='color:#4453EA'>www.avast.com</span></a></span><o:p></o:p></p></div></td></tr></table></div></div></blockquote></div></div></div></blockquote></div><p class=MsoNormal><o:p> </o:p></p></div></div></body></html>