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: Description: Image removed by sender. Documentation

#1045 - Access denied for user 'root'@'localhost' (using password: NO)




--

Anthony Stefan Maciejowski