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() [<a href=‘Application\
Docs/Programming/PHP/phpmanual/mysqli.real-connect’>mysqli.real-connect</a>:
(HY000/2002): No such file or directory.
Connection for controluser as defined in your configuration failed.
I’m particularly puzzled by that “No such file or directory” message, because
the file Application\ Docs/Programming/PHP/phpmanual/mysqli.real-connect does
exist: I installed the phymyadmin doc files to Application\
Docs/Programming/PHP/phpmanual.
From my web search, this seems to have something to do with mysql’s method of
authentication, but what I’ve found presents a bewildering variety of different
ways to fix the issue. And it’s not clear which methods are destructive of
existing databases and which not, nor which are suitable for the particular
situation when both mysql8 and phpmyadmin are the MacPorts versions.
Can you provide any insight or help as to how to proceed?
---
Murray Eisenberg [email protected]
503 King Farm Blvd #101 Home (240)-246-7240
Rockville, MD 20850-6667 Mobile (413)-427-5334
