[support] PHPMyAdmin access error

[Paul Simard]

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 at drupal.org [mailto:support-bounces at drupal.org] On
Behalf Of Anthony
Sent: Thursday, May 10, 2012 6:23 PM
To: support at 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) 




-- 

Anthony Stefan Maciejowski

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20120511/76ded6f4/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 335 bytes
Desc: not available
Url : http://lists.drupal.org/pipermail/support/attachments/20120511/76ded6f4/attachment.jpe