phpMyAdmin - mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'

Hello,

after installing phpmyadmin on Ubuntu via PPA:
sudo add-apt-repository ppa:phpmyadmin/ppa
sudo apt-get update
sudo apt-get install phpmyadmin

I have a problem logging into phpMyAdmin for a database with this error:
Welcome to phpMyAdmin
Cannot log in to the MySQL server
Username: root
Password: xxx
mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'

Thank you for your help

REPLY

Hello,

error Cannot log in to MySQL server - mysqli_real_connect (): (HY000 / 1698): To resolve access denied for user 'root' @ 'localhost':

1.) Set the root password according to this manual , ie.
mysql -uroot
set password = "(mypass");
2.) If this doesn't happen immediately, restart the mysql server