Re: MySQL 8: datadir

2020-10-04 Thread Jeffrey Walton
On Sun, Oct 4, 2020 at 10:57 AM Murray Eisenberg wrote: > > Problem SOLVED! > > Trouble was in my.cnf I had specified > > pid-file = /opt/local/var/run/mysq8/mysqld.pid > > but apparently mysqld could not write to that directory — even though I had > previously executed > > sudo chown -R

Re: MySQL 8: datadir

2020-10-04 Thread Murray Eisenberg
Problem SOLVED! Trouble was in my.cnf I had specified pid-file = /opt/local/var/run/mysq8/mysqld.pid but apparently mysqld could not write to that directory — even though I had previously executed sudo chown -R _mysql:_mysql /opt/local/var/run/mysql8/ and when I checked

Re: MySQL 8: datadir

2020-10-04 Thread Ryan Schmidt
On Oct 3, 2020, at 12:05, Murray Eisenberg wrote: > On 3 Oct2020, at 8:00 AM,Andrew Udvare wrote: > >> 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

Re: MySQL 8: datadir

2020-10-03 Thread Murray Eisenberg
> On 3 Oct2020, at 8:00 AM,Andrew Udvare > wrote: > > 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

Re: MySQL 8: datadir

2020-10-03 Thread Murray Eisenberg
No, I do not find any my.cnf in my datadir. There were two problems here, the first of which I’ve fixed. (1) FIXED: Trouble caused by mysql client binary being no found or pointing to mysql57 rather than mysql8. - For my default interactive shell zsh, getting rid of loading

Re: MySQL 8: datadir

2020-10-02 Thread Andrew Udvare
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

Re: MySQL 8: datadir

2020-10-02 Thread Ryan Schmidt
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

Re: MySQL 8: datadir

2020-10-02 Thread Murray Eisenberg
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

Re: MySQL 8: datadir

2020-10-02 Thread Ryan Schmidt
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

Re: MySQL 8: datadir

2020-10-02 Thread Murray Eisenberg
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!

Re: MySQL 8: datadir

2020-10-02 Thread Ryan Schmidt
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.

MySQL 8: datadir

2020-10-02 Thread Murray Eisenberg
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