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: *[image: Documentation]http://localhost:8080/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Ferror-messages-server.html&token=e7d2156712abd6a7b93a5e76ff5d6639 #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Correct
In the php.ini?
tony mac is building web sites.
-----Original Message----- From: Steve stever@up-south.com Sender: support-bounces@drupal.org Date: Thu, 10 May 2012 15:25:52 To: support@drupal.org; support@drupal.org Reply-To: support@drupal.org Subject: Re: [support] PHPMyAdmin access error
Search for config.inc.php mine is in /etc/webapps/phpmyadmin/config.inc.php
--jerry
On Thu, May 10, 2012 at 5:22 PM, Anthony tony@tony-mac.com wrote:
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: *[image: Documentation]http://localhost:8080/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Ferror-messages-server.html&token=e7d2156712abd6a7b93a5e76ff5d6639 #1045 - Access denied for user 'root'@'localhost' (using password: NO)
--
*Anthony Stefan Maciejowski*
-- [ Drupal support list | http://lists.drupal.org/ ]
On Thu, May 10, 2012 at 6:22 PM, Anthony tony@tony-mac.com wrote:
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:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
Is this BlueHost or somewhere else? phpMyAdmin can be touchy with password changes. Clear the browser cache and try again.
-- Earnie -- https://sites.google.com/site/earnieboyd
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)
-
Anthony -
Earnie Boyd -
Gerald Klein -
Paul Simard -
Steve -
Tony MAC