Apache Friends Support Forum

Okay, so I want to build WordPress themes. To help with this I want to run a local installation of WordPress. So I loaded Xampp. Got MySQL and Apache up and running. Went to localhost to make sure everything is working alright, it seemed to be. Then I went to PHPMyAdmin to configure a database for WordPress to use. And I get a message that says "Access denied for user 'root'@'localhost'."

So apparently I set up a database previously on my computer and have forgotten about it, not to mention the login info for it. How can I go about removing the old databse, or at least having Xampp not try to use that particular database?

Hi TorroesPrime,

TorroesPrime wrote:So apparently I set up a database previously on my computer and have forgotten about it, not to mention the login info for it.

It is not a database, it is the user credential itself. You have created a password for the user root (maybe with the help of the XAMPP security page) and phpmyadmin needs to know that new password.

So if you remember that password, you can change the \xampp\phpmyadmin\config.inc.php file to either change the auth_type setting to the value cookie and login yourself (recommend), or type in your password as value for the password setting (not recommend).

If you don't have a clue what the password was about you can just reset your password with the tool \xampp\mysql\resetroot.bat (mysql needs to be shutdown for this).

best wishes,
Altrea