<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Assuming I do _not_ want to initialize the database, given that I want to use an existing (MySQL 5.7) database with the newly installed MySQL8, I loaded mysql8-server, then tried to connect to it:<div class=""><br class=""></div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span><span style="font-family: Menlo; font-size: 13px;" class="">mysql</span></div><div class=""><div style="margin: 0px; font-stretch: normal; font-size: 13px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql57/mysqld.sock' (2)</span></div><div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div>Note:</div><div><br class=""></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><span style="font-family: Menlo; font-size: 13px;" class="">sudo port select --show mysql</span></div><div><div style="margin: 0px; font-stretch: normal; font-size: 13px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>The currently selected version for 'mysql' is 'mysql8’.</span></div><div style="margin: 0px; font-stretch: normal; font-size: 13px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class="">So the error from trying to execute ‘mysql’ is surprising! Here’s my configuration file <span style="font-family: Menlo; font-size: 13px;" class="">/opt/local/etc/mysql8/my.cnf</span><span style="font-family: Menlo; font-size: 13px;" class=""> :</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-family: Menlo; font-size: 13px;" class=""><br class=""></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><font face="Menlo" size="2" class=""><span class="Apple-tab-span" style="white-space:pre"> </span># Use default MacPorts settings</font></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><font face="Menlo" size="2" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>!include /opt/local/etc/mysql8/macports-default.cnf</font></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><font face="Menlo" size="2" class=""><br class=""></font></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><font face="Menlo" size="2" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>[mysqld]</font></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>datadir = /Users/murray/Databases/mysql/data</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><font face="Menlo" size="2" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>port = 3306</font></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><font face="Menlo" size="2" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>socket = /opt/local/var/run/mysql8/mysqld.sock</font></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><font face="Menlo" size="2" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>pid-file = /opt/local/var/run/mysqld/mysqld.pid</font></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><font face="Menlo" size="2" class=""><br class=""></font></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><font face="Menlo" size="2" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES </font></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><font face="Menlo" size="2" class=""><br class=""></font></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><font face="Menlo" size="2" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>[client]</font></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><font face="Menlo" size="2" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>socket = /opt/local/var/run/mysql8/mysqld.sock</font></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><font face="Menlo" size="2" class=""><br class=""></font></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class="">What’s wrong??</div></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-family: Menlo; font-size: 13px;" class=""><br class=""></span></div></div><div><blockquote type="cite" class=""><div class="">On 2 Oct2020, at 6:17 PM, Murray Eisenberg <<a href="mailto:murrayeisenberg@gmail.com" class="">murrayeisenberg@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">Andrew Audvare’s separate reply (for some reason not showing yet in my email, although sent before yours), advised:<br class=""><br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>- stopmysql 5.7 [no problem: I can’t start it!!]<br class=""><br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>- backup existing 5.7 database<br class=""><br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>- move my.cnf to "appropriate location" <— not sure what this means! Surely I want it to be in /opt/local/etc/mysql8<br class=""><br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>- start mysql8<br class=""><br class="">BUT what about the mysql8 initialization step: do I want to SKIP that, since I already have a mysql 5.7 database to use (i.e., to upgrade automatically)? Does the initialization do anything else besides creating a new database?<br class=""><br class=""><br class=""><blockquote type="cite" class="">On 2 Oct2020, at 5:37 PM, Ryan Schmidt <<a href="mailto:ryandesign@macports.org" class="">ryandesign@macports.org</a>> wrote:<br class=""><br class=""><br class=""><br class="">On Oct 2, 2020, at 15:45, Murray Eisenberg wrote:<br class=""><br class=""><blockquote type="cite" class="">Step 6: Database upgrade as necessary<br class=""></blockquote><br class="">You used to have to upgrade the database manually but according to Oracle's documentation mysql 8.0.16 and later do it for you automatically.<br class=""><br class=""><br class=""><a href="https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html" class="">https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html</a><br class=""><br class=""><br class="">That's just one of many pages in the section of their manual on upgrading. There may be other useful information in there for you.<br class=""><br class=""></blockquote><br class="">---<br class="">Murray Eisenberg<span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span><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=""><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<br class=""><br class="">
</div>
<br class=""></div></body></html>