phpmyadmin 5.0.2 with mysql 8

Murray Eisenberg murrayeisenberg at gmail.com
Sun Oct 4 15:27:41 UTC 2020


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			murrayeisenberg at gmail.com
503 King Farm Blvd #101	Home (240)-246-7240
Rockville, MD 20850-6667	Mobile (413)-427-5334




More information about the macports-users mailing list