<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="">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 style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);" class="">sudo /opt/local/lib/mysql57/bin/mysql_upgrade -u root -p</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="">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 style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);" class="">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 style="font-family: Menlo; font-size: 12px; background-color: rgb(255, 255, 255);" class=""> while connecting to the MySQL server</span></div><div style="margin: 0px; font-size: 12px; line-height: normal; font-family: Menlo; background-color: rgb(255, 255, 255);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> Upgrade process encountered error and will not continue.</span></div><div style="margin: 0px; font-size: 12px; line-height: normal; font-family: Menlo; background-color: rgb(255, 255, 255);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div style="margin: 0px; font-size: 12px; line-height: normal; font-family: Menlo; background-color: rgb(255, 255, 255);" class=""><span style="font-family: Helvetica; font-size: 14px;" class="">On the other hand, if I start mysql57-server and then execute</span></div><div style="margin: 0px; font-size: 12px; line-height: normal; font-family: Menlo; background-color: rgb(255, 255, 255);" class=""><span style="font-family: Helvetica; font-size: 14px;" class=""><br class=""></span></div><div style="margin: 0px; font-size: 12px; line-height: normal; font-family: Menlo; background-color: rgb(255, 255, 255);" class=""><span style="font-family: Helvetica; font-size: 14px;" class=""> </span>mysql -u root -p</div><div style="margin: 0px; font-size: 12px; line-height: normal; font-family: Menlo; background-color: rgb(255, 255, 255);" class=""><br class=""></div><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class="">and give the mysql database root password, I can successfully interact with the mysql sever (e.g., “show databases”).</div><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class=""><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></body></html>