<div dir="auto">Did you do the initial set up?<div dir="auto"><br></div><div dir="auto">You can take a look at the log in /opt/local/var/log/mysql</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Oct 3, 2020, 15:11 Murray Eisenberg <<a href="mailto:murray@math.umass.edu">murray@math.umass.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word;line-break:after-white-space">Something seems to be wrong:<div><br></div><div><span style="white-space:pre-wrap">  </span>sudo port<span style="font-family:Menlo;font-size:13px"> load mysql8-server</span></div><div><div style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures">-->  Loading startupitem 'mysql8-server' for mysql8-server</span></div><div style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><br></span></div><div style="margin:0px;font-stretch:normal;line-height:normal"><div style="font-family:Menlo;font-size:13px;margin:0px;font-stretch:normal;line-height:normal"><span style="font-variant-ligatures:no-common-ligatures"><span style="font-family:Helvetica;font-size:14px;white-space:pre-wrap">       </span>ps -ax | grep mysql</span></div><div style="font-family:Menlo;font-size:13px;margin:0px;font-stretch:normal;line-height:normal"><span style="font-variant-ligatures:no-common-ligatures">39298 ttys001</span>    0:00.00 grep mysql</div><div style="font-family:Menlo;font-size:13px;margin:0px;font-stretch:normal;line-height:normal"><br></div><div style="font-family:Menlo;font-size:13px;margin:0px;font-stretch:normal;line-height:normal"><span style="font-family:Helvetica;font-size:14px">Is the mysql8 server actually running??</span></div><div style="font-family:Menlo;font-size:13px;margin:0px;font-stretch:normal;line-height:normal"><span style="font-family:Helvetica;font-size:14px"><br></span></div><div style="margin:0px;font-stretch:normal;line-height:normal">Should there be a process found for mysqld?</div><div style="margin:0px;font-stretch:normal;line-height:normal"><br></div></div><div><blockquote type="cite"><div>On 3 Oct2020, at 1:52 PM, Herby G <<a href="mailto:herby.gillot@gmail.com" target="_blank" rel="noreferrer">herby.gillot@gmail.com</a>> wrote:</div><br><div><div dir="auto">Hello Murray,<div dir="auto"><br></div><div dir="auto">Instructions for setting up mysql8-server after installation with MacPorts are shown in the console right after installation.</div><div dir="auto"><br></div><div dir="auto">You can review these using 'port notes':</div><div dir="auto"><br></div><div dir="auto">$ port notes mysql8-server</div><div dir="auto"><br></div><div dir="auto">Then you would start the mysql8-server service using 'port load':</div><div dir="auto"><br></div><div dir="auto">$ sudo port load mysql8-server</div><div dir="auto"><br></div><div dir="auto">To stop and disable the service, use 'port unload':</div><div dir="auto"><br></div><div dir="auto">$ sudo port unload mysql8-server</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Oct 3, 2020, 13:38 MacPorts <<a href="mailto:noreply@macports.org" target="_blank" rel="noreferrer">noreply@macports.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">#61267: Error in mysqld_safe from mysql8-server<br>
--------------------------+---------------------------<br>
 Reporter:  murrayE       |      Owner:  (none)<br>
     Type:  defect        |     Status:  new<br>
 Priority:  Normal        |  Milestone:<br>
Component:  ports         |    Version:  2.6.3<br>
 Keywords:  syntax error  |       Port:  mysql8-server<br>
--------------------------+---------------------------<br>
 After installing mysql8-server, I tried running it with command:<br>
<br>
 {{{<br>
 sudo /opt/local/share/mysql8/support-files/mysql.server start<br>
 }}}<br>
<br>
 After the prompt for, and giving, my password, the following happens:<br>
<br>
 {{{<br>
 Starting MySQL<br>
 ./opt/local/bin/mysqld_safe: line 810: syntax error near unexpected token<br>
 `then'<br>
 /opt/local/bin/mysqld_safe: line 810: `    then    # The pid contains a<br>
 mysqld process'<br>
  ERROR! The server quit without updating PID file<br>
 (/opt/local/var/run/mysqld/mysqld.pid).<br>
 }}}<br>
<br>
-- <br>
Ticket URL: <<a href="https://trac.macports.org/ticket/61267" rel="noreferrer noreferrer noreferrer" target="_blank">https://trac.macports.org/ticket/61267</a>><br>
MacPorts <<a href="https://www.macports.org/" rel="noreferrer noreferrer noreferrer" target="_blank">https://www.macports.org/</a>><br>
Ports system for macOS<br>
</blockquote></div>
</div></blockquote></div><br><div>
<div style="color:rgb(0,0,0);letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word;line-break:after-white-space"><div style="color:rgb(0,0,0);letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word;line-break:after-white-space"><div><div>——</div><div>Murray Eisenberg                                <a href="mailto:murray@math.umass.edu" target="_blank" rel="noreferrer">murray@math.umass.edu</a></div><div>Professor Emeritus</div><div>Mathematics & Statistics Dept.       </div><div>University of Massachusetts </div><div>Amherst, MA USA</div></div><div><br></div></div><br></div><br><br>
</div>
<br></div></div></blockquote></div>