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: *[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*
Correct -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. 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) -- Anthony Stefan Maciejowski
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 -- [ Drupal support list | http://lists.drupal.org/ ]
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/ ]
-- Gerald Klein DBA**** ContactMe@geraldklein.com www.geraldklein.com <http://geraldklein.com/>**** jk@zognet.com**** 708-599-0352**** Linux registered user #548580
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 Stefan Maciejowski
participants (6)
-
Anthony -
Earnie Boyd -
Gerald Klein -
Paul Simard -
Steve -
Tony MAC