Anthony,
PHPMyadmin is a web application, completely separate from MySQL, Drupal, or anything other than itself. As such, it has its own configuration data storage. If you changed the root password using the MySQL client, PHPMyadmin would be unaware of it.
As a last resort, I'd suggest renaming the password to the previous password again, then changing it through PHPMyadmin. You should search for the database connection in the file 'config.inc.php' in the PHPMyadmin root directory. The section you want is generally within the first 20 lines of the file. The lines you are searching for are in the
/* Authentication and type info */ block.
You didn't say whether you are using a development stack on your machine, or a development environment on a server, or a production environment on a server. This can present difficulties if you cannot access the config.inc.php file.
Paul
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Anthony Sent: Thursday, May 10, 2012 6:23 PM To: support@drupal.org Subject: [support] PHPMyAdmin access error
I changed the myql user password for user root in mysql. Now I can't get into phpMyadmin because I assume phpMyAdmin has the password stored somewhere apart from mysql (guessing here) . With the error:
Error
MySQL said: http://localhost:8080/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fd oc%2Frefman%2F5.0%2Fen%2Ferror-messages-server.html&token=e7d2156712abd6a7b9 3a5e76ff5d6639 Description: Image removed by sender. Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
