I've set up a new CentOS 7 server with Apache, MySQL and phpMyAdmin using Digital Ocean's guides.
However, when I try to log in to phpMyAdmin via the browser, I get the message "Cannot log in to the MySQL server" with...
Assuming MySQL 8.
ALTER USER root IDENTIFIED WITH mysql_native_password BY 'PASSWORD';
Some applications are having trouble with <^>caching _sha2 _password<^> method. Above sets the credentials to use the...