Your client is trying to connect /opt/local/var/run/mysql57/mysqld.sock instead of /opt/local/var/run/mysql8/mysqld.sock . Your client is not finding the correct socket path in my.cnf. You can specify which socket to connect to manually:
mysql -S /opt/local/var/run/mysql8/mysqld.sock ... If you are running mysql8, does /opt/local/var/run/mysql8/mysqld.sock exist? It may be that your my.cnf says to put it at the old path. On Fri, 2 Oct 2020 at 20:36, Murray Eisenberg <murrayeisenb...@gmail.com> wrote: > > 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: > > mysql > ERROR 2002 (HY000): Can't connect to local MySQL server through socket > '/opt/local/var/run/mysql57/mysqld.sock' (2) > > Note: > > sudo port select --show mysql > The currently selected version for 'mysql' is 'mysql8’. > > So the error from trying to execute ‘mysql’ is surprising! Here’s my > configuration file /opt/local/etc/mysql8/my.cnf : > > # Use default MacPorts settings > !include /opt/local/etc/mysql8/macports-default.cnf > > [mysqld] > datadir = /Users/murray/Databases/mysql/data > port = 3306 > socket = /opt/local/var/run/mysql8/mysqld.sock > pid-file = /opt/local/var/run/mysqld/mysqld.pid > > sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES > > [client] > socket = /opt/local/var/run/mysql8/mysqld.sock > > What’s wrong?? > > On 2 Oct2020, at 6:17 PM, Murray Eisenberg <murrayeisenb...@gmail.com> wrote: > > Andrew Audvare’s separate reply (for some reason not showing yet in my email, > although sent before yours), advised: > > - stopmysql 5.7 [no problem: I can’t start it!!] > > - backup existing 5.7 database > > - move my.cnf to "appropriate location" <— not sure what this means! Surely I > want it to be in /opt/local/etc/mysql8 > > - start mysql8 > > 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? > > > On 2 Oct2020, at 5:37 PM, Ryan Schmidt <ryandes...@macports.org> wrote: > > > > On Oct 2, 2020, at 15:45, Murray Eisenberg wrote: > > Step 6: Database upgrade as necessary > > > 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. > > > https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html > > > 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. > > > --- > Murray Eisenberg murrayeisenb...@gmail.com > 503 King Farm Blvd #101 Home (240)-246-7240 > Rockville, MD 20850-6667 Mobile (413)-427-5334 > > > > --- > Murray Eisenberg murrayeisenb...@gmail.com > 503 King Farm Blvd #101 Home (240)-246-7240 > Rockville, MD 20850-6667 Mobile (413)-427-5334 > >
