<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Think I solved it.<div class=""><br class=""></div><div class="">First, one and only one password is needed, namely, that for mysql. (Assuming I’ve run sudo recently before the timeout that would prompt for a new macOS password.)</div><div class=""><br class=""></div><div class="">Second, even though the MacPorts docs for MySQL in Step 6 gives...</div><div class=""><br class=""></div><div class=""><pre class="wiki" style="background-color: rgb(247, 247, 247); border: 1px solid rgb(215, 215, 215); box-shadow: rgb(238, 238, 238) 0px 0px 1em; border-top-left-radius: 0.3em; border-top-right-radius: 0.3em; border-bottom-right-radius: 0.3em; border-bottom-left-radius: 0.3em; margin: 1em 1.75em; padding: 0.25em; overflow: auto; font-size: 13px;">sudo port unload mysql57-server</pre><div class="">…before</div><pre class="wiki" style="background-color: rgb(247, 247, 247); border: 1px solid rgb(215, 215, 215); box-shadow: rgb(238, 238, 238) 0px 0px 1em; border-top-left-radius: 0.3em; border-top-right-radius: 0.3em; border-bottom-right-radius: 0.3em; border-bottom-left-radius: 0.3em; margin: 1em 1.75em; padding: 0.25em; overflow: auto; font-size: 13px;">sudo /opt/local/lib/mysql57/bin/mysql_upgrade -u root -p</pre><div class=""><br class=""></div><div class="">…it seems that one nevertheless does have to start the mysql server in order to cause a socket to exist and allow to <span style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);" class="">mysql_upgrade</span> execute.</div><div class=""><br class=""></div><div class="">And, in fact, <span style="font-size: 13px; background-color: rgb(247, 247, 247);" class="">man mysql_upgrade</span> includes the explicit instructions:</div><div class=""><br class=""></div><div class=""> <span style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);" class="">To use </span><b style="font-family: Menlo; font-size: 12px;" class="">mysql_upgrade</b><span style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);" class="">, make sure that the server is running.</span><span style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);" class=""> </span></div><div class=""><br class=""></div><div class="">That worked for me, and execution of <span style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);" class="">mysql_upgrade</span> ended with message:</div><div class=""><br class=""></div><div class=""> <span style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);" class="">Upgrade process completed successfully.</span></div><div class=""><span style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);" class=""><br class=""></span></div><div class=""><br class=""></div><div class="">Question remaining: Am I just misunderstanding what starting/loading and stopping/unloading the mysql-server means? Rather than “load” and “unload”, I always use: </div><div class=""><br class=""></div><div class=""> <span style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);" class="">sudo /opt/local/share/mysql57/support-files/mysql.server start</span></div><div class=""><span style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);" class=""><br class=""></span></div><div class=""><span style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);" class=""> </span><span style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);" class="">sudo /opt/local/share/mysql57/support-files/mysql.server stop</span></div><div class=""><span style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);" class=""><br class=""></span></div><div class="">(Actually, via aliases defined in ~/.profile, I actually use much shorter commands “mysqlstart” and “mysqlstop”.</div><div class=""><br class=""></div><div class="">Or is there an error now in the Step 6 instructions? </div><div><blockquote type="cite" class=""><div class="">On 27 Oct2017, at 12:34 PM, Murray Eisenberg <<a href="mailto:murrayeisenberg@gmail.com" class="">murrayeisenberg@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><span style="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; float: none; display: inline !important;" class="">Typo in my post, sorry.</span><div class="" style="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;"><br class=""></div><div class="" style="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;">As the cited MacPorts doc for MySQL specify, I’m actually issuing the command...</div><div class="" style="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;"><div class=""><br class=""></div><div class=""> <span class="" style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);">sudo /opt/local/lib/mysql57/bin/mysql_upgrade -u root -p</span></div><div class=""><span class="" style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);"><br class=""></span></div><div class="">.. with the prefix <span class="" style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);">sudo<span class="Apple-converted-space"> </span></span>to the <span class="" style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);">mysql_upgrade </span>command, there do seem to be two passwords involved, one for the <span class="" style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);">sudo </span>and a second for <span class="" style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);">mysql_upgrade.</span></div><div class=""> </div><div class="">(I do understand that MySQL knows nothing about my OS password!)<div class=""><br class=""></div><div class=""><br class=""></div><div class=""><div class=""><blockquote type="cite" class=""><div class="">On 27 Oct2017, at 12:28 PM, Marius Schamschula <<a href="mailto:mschamschula@gmail.com" class="">mschamschula@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="" style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Murray,<div class=""><br class=""></div><div class="">This is the mysql root password. MySQL has no knowledge of your OS password.</div><div class=""><br class=""><div class=""><div class="" style="font-family: Helvetica; font-size: 12px; 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;">Marius</div><div class="" style="font-family: Helvetica; font-size: 12px; 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;">--</div><div class="" style="font-family: Helvetica; font-size: 12px; 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;">Marius Schamschula</div><div class="" style="font-family: Helvetica; font-size: 12px; 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;"><br class=""></div><br class="Apple-interchange-newline"></div><br class=""><div class=""><blockquote type="cite" class=""><div class="">On Oct 27, 2017, at 11:26 AM, Murray Eisenberg <<a href="mailto:murrayeisenberg@gmail.com" class="">murrayeisenberg@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="" style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">I’m upgrading msql56 -> mysql57.<div class=""><br class=""></div><div class="">Step 6 in Documentation at <a href="https://trac.macports.org/wiki/howto/MySQL" class="">https://trac.macports.org/wiki/howto/MySQL</a> says:<div class=""><br class=""></div><div class=""> "If the database exists from a previous installation, you may need to upgrade.”</div><div class=""><br class=""></div><div class="">After unloading mysql57-server, as recommended there I execute:</div><div class=""><br class=""></div><div class=""> <span class="" style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);">mysql_upgrade</span><span class="" style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);"> /opt/local/lib/mysql57/bin/mysql_upgrade -u root -p</span></div></div></div></div></blockquote></div></div></div></div></blockquote><blockquote type="cite" class=""><div class="" style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div class=""><div class=""><blockquote type="cite" class=""><div class=""><div class="" style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div class=""><div class=""><span class="" style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);"><br class=""></span></div><div class="">After Question: which password should be entered in response to the prompt: my macOS admin account’s password or the mysql root’s password?</div><div class=""><br class=""></div><div class="">Or, if both are required, which do I enter first?</div><div class=""><br class=""></div><div class="">If I just enter my macOS admin account’s password, I get error”</div><div class=""><br class=""></div><div class=""> <span class="" style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);">mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/opt/local/var/run/mysql57/mysqld.sock' (2) </span></div><div class=""><span class="" style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);"> while connecting to the MySQL server</span></div><div class="" style="margin: 0px; font-size: 12px; line-height: normal; font-family: Menlo; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures: no-common-ligatures;"> Upgrade process encountered error and will not continue.</span></div><div class="" style="margin: 0px; font-size: 12px; line-height: normal; font-family: Menlo; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures: no-common-ligatures;"><br class=""></span></div><div class="" style="margin: 0px; font-size: 12px; line-height: normal; font-family: Menlo; background-color: rgb(255, 255, 255);"><span class="" style="font-family: Helvetica; font-size: 14px;">On the other hand, if I start mysql57-server and then execute</span></div><div class="" style="margin: 0px; font-size: 12px; line-height: normal; font-family: Menlo; background-color: rgb(255, 255, 255);"><span class="" style="font-family: Helvetica; font-size: 14px;"><br class=""></span></div><div class="" style="margin: 0px; font-size: 12px; line-height: normal; font-family: Menlo; background-color: rgb(255, 255, 255);"><span class="" style="font-family: Helvetica; font-size: 14px;"> </span>mysql -u root -p</div><div class="" style="margin: 0px; font-size: 12px; line-height: normal; font-family: Menlo; background-color: rgb(255, 255, 255);"><br class=""></div><div class="" style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);">and give the mysql database root password, I can successfully interact with the mysql sever (e.g., “show databases”).</div><div class="" style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);"><br class=""></div><div class=""><div class="">---<br class="">Murray Eisenberg<span class="Apple-tab-span" style="white-space: pre;"> </span><a href="mailto:murrayeisenberg@gmail.com" class="">murrayeisenberg@gmail.com</a><br class="">503 King Farm Blvd #101<span class="Apple-tab-span" style="white-space: pre;"> </span>Home (240)-246-7240<br class="">Rockville, MD 20850-6667<span class="Apple-tab-span" style="white-space: pre;"> </span>Mobile (413)-427-5334<br class=""><br class=""></div><br class=""></div></div></div></div></blockquote></div><br class=""></div></div></blockquote></div><br class=""><div class="">---<br class="">Murray Eisenberg<span class="Apple-tab-span" style="white-space: pre;"> </span><a href="mailto:murrayeisenberg@gmail.com" class="">murrayeisenberg@gmail.com</a><br class="">503 King Farm Blvd #101<span class="Apple-tab-span" style="white-space: pre;"> </span>Home (240)-246-7240<br class="">Rockville, MD 20850-6667<span class="Apple-tab-span" style="white-space: pre;"> </span>Mobile (413)-427-5334</div></div></div></div></div></blockquote></div><br class=""><div class="">
---<br class="">Murray Eisenberg<span class="Apple-tab-span" style="white-space: pre;"> </span><a href="mailto:murrayeisenberg@gmail.com" class="">murrayeisenberg@gmail.com</a><br class="">503 King Farm Blvd #101<span class="Apple-tab-span" style="white-space: pre;"> </span>Home (240)-246-7240<br class="">Rockville, MD 20850-6667<span class="Apple-tab-span" style="white-space: pre;"> </span>Mobile (413)-427-5334<br class=""><br class="">
</div>
<br class=""></div></body></html>