Im trying to intall and configure phpmyadmin on a Apache2 server (Debian), but when i try to access im getting the following error: #1045 - Access denied for user 'root'@'localhost' (using password: YES).The folder of phpmyadmin is located in /var/www/phpmyadmin and the password of config.inc.php is the same password of the user root of MySQL, however i obtain the error #1045.
I've installed xampp on my MAC computer in my table I saw a word named user I clicked it and I saw that I was able to change from not having a password by default to using a password. I clicked it and filled in a password. Afterwards I was banned from mu phpadmin and my table.
This is a new install and I have only set the root passwords for localhost, 127.0.0.1 and .
I know the password is correct as I can log in with root@localhost to the mysql server and can also create users. However, when I try to grant privileges to the newly created user I get the dreaded "Access denied for user root@localhost (using password: YES)" error message.