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 a
On Oct 2, 2020, at 19:36, Murray Eisenberg 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 2
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 socke
On Oct 2, 2020, at 17:17, Murray Eisenberg wrote:
> - move my.cnf to "appropriate location" <— not sure what this means!
> Surely I want it to be in /opt/local/etc/mysql8
According to "port notes mysql8" I agree that's the appropriate location.
> - start mysql8
>
> BUT what abou
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!
Surel
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-u
On 02/10/2020 16:45, Murray Eisenberg wrote:
> I have an existing MacPorts mysql57 installation (but mysql is not currently
> working: the dreaded PID file cannot be found error).
> —> I have an existing mysql57 datadir, namely, as specified in
> /opt/local/etc/mysql57/my.cnf:
>
> datadir
I have an existing MacPorts mysql57 installation (but mysql is not currently
working: the dreaded PID file cannot be found error).
—> I have an existing mysql57 datadir, namely, as specified in
/opt/local/etc/mysql57/my.cnf:
datadir = /Users/murray/Databases/mysql/data
So I’m trying ane
