Published Question
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...
Accepted Answer:
Assuming MySQL 8.
ALTER USER root IDENTIFIED WITH mysql_native_password BY 'PASSWORD';
Reason:
Some applications are having trouble with <^>caching _sha2 _password<^> method. Above sets the credentials to use the...
4
•
•
By
NielsKersic
MySQL
Databases
CentOS