Re: MySQL 8 configuring errors on M1 machines

2021-09-04 Thread 조성빈
y email > provider is a spammer.) That would be annoying… My experience was the opposite though – the MacPorts mailing list frequently thinks that I’m a spammer for some reason. :-( > Sent: Thursday, September 02, 2021 at 9:57 AM > From: "조성빈" > Subject: MySQL 8 configuring err

Re: MySQL 8 configuring errors on M1 machines

2021-09-04 Thread Christopher Chavez
2021 at 9:57 AM From: "조성빈" Subject: MySQL 8 configuring errors on M1 machines > Can anyone check if requesting a MySQL 8 install errors out in configure > stage on M1 machines? The port needs to be updated to MySQL 8.0.26 in order to build on Apple Silicon, accordin

Re: MySQL 8 configuring errors on M1 machines

2021-09-04 Thread Christopher Chavez
Sent: Thursday, September 02, 2021 at 9:57 AM From: "조성빈" Subject: MySQL 8 configuring errors on M1 machines > Can anyone check if requesting a MySQL 8 install errors out in configure > stage on M1 machines? The port needs to be updated to MySQL 8.0.26 in order to build o

MySQL 8 configuring errors on M1 machines

2021-09-02 Thread 조성빈
Hello, Can anyone check if requesting a MySQL 8 install errors out in configure stage on M1 machines? Running sudo port install mysql8 has been failing for some time – it did install a few months ago. Since some point it started to fail upgrading, . I’ve been reading the log files (attached

Re: phpmyadmin 5.0.2 with mysql 8

2020-10-04 Thread Ryan Schmidt
On Oct 4, 2020, at 16:22, Murray Eisenberg wrote: > On 4 Oct2020, at 4:29 PM, Ryan Schmidt wrote: > >> On Oct 4, 2020, at 10:27, Murray Eisenberg wrote: >> >>> I’ve finally succeeded in upgrading from mysql 5.7 to mysql 8 (8.0.21) but >>> now my existing

Re: phpmyadmin 5.0.2 with mysql 8

2020-10-04 Thread Murray Eisenberg
> On 4 Oct2020, at 4:29 PM, Ryan Schmidt wrote: > > On Oct 4, 2020, at 10:27, Murray Eisenberg wrote: > >> I’ve finally succeeded in upgrading from mysql 5.7 to mysql 8 (8.0.21) but >> now my existing phymyadmin 5.0.2 no longer allows me to log in as root. >>

Re: phpmyadmin 5.0.2 with mysql 8

2020-10-04 Thread Ryan Schmidt
On Oct 4, 2020, at 10:27, Murray Eisenberg wrote: > I’ve finally succeeded in upgrading from mysql 5.7 to mysql 8 (8.0.21) but > now my existing phymyadmin 5.0.2 no longer allows me to log in as root. > > One dragon slayed; another appeared! > > Errors: >

phpmyadmin 5.0.2 with mysql 8

2020-10-04 Thread Murray Eisenberg
I’ve finally succeeded in upgrading from mysql 5.7 to mysql 8 (8.0.21) but now my existing phymyadmin 5.0.2 no longer allows me to log in as root. One dragon slayed; another appeared! Errors: Cannot log in to the MySQL server mysqli::real_connect() [mysqli.real-connect

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
ase. Very confusing: I want to use the old one, updated to MySQL 8. Step 4: Set the MySQL password (OK, I guess) Step 5 (Optional security configuration) Step 6: Database upgrade as necessary This is very confusing, too! I already have that old mysql57 database, in a non-default datadir

Re: mysql 8?

2019-02-21 Thread Ryan Schmidt
On Feb 21, 2019, at 09:47, Murray Eisenberg wrote: > What is the status of, or plans for, MySQL version 8.0 (the current release) https://trac.macports.org/ticket/57776 > and supporting ports, e.g., phpxx-mysql and phpmyqdmin? They would presumably be updated after the mysql8 port exists.

mysql 8?

2019-02-21 Thread Murray Eisenberg
What is the status of, or plans for, MySQL version 8.0 (the current release) and supporting ports, e.g., phpxx-mysql and phpmyqdmin? --- Murray Eisenbergmurrayeisenb...@gmail.com 503 King Farm Blvd #101 Home (240)-246-7240 Rockville, MD 20850-6667Mobile