WordPress Messed Up My Database

I downloaded and installed WordPress on a Mac running MAMP and created a new database named wordpress. I then tried to figure out how to do a multisite-subdomain installation, but I couldn’t get it to work. So I deleted the wordpress folder from htdocs.

I then discovered that I can’t use phpMyAdmin. I can still view the MAMP home page @ http://localhost/MAMP/

But when I click on the link to phpMyAdmin @ http://localhost/MAMP/index.php?page=phpmyadmin&language=English I get this error message:

#1045 - Access denied for user ‘root’@‘localhost’ (using password: YES)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Has anyone had this experience with WordPress? I’m not sure what file I’m supposed to look for or fix. Thanks for any tips.

not familiar w/mamp, have xampp myself. And have not experienced this w/wp.
(Also we can’t open links you have on localhost)
In my experience i access localhost/xampp and there i click on the admin @ http://localhost/phpmyadmin/
I wonder if your link w/the index.php is taking you to the no longer existing wp page?
& of course you are running it as administrator correct?

Yes, I’m running it as an administrator.

MySQL passwords are SO confusing, I finally gave up and just used Time Machine to restore my machine to an earlier date. I’m going to try and find a local WordPress consultant to install it for me.


of course as long as it is your local host you can just use no password.
just go to the wp-config.php file and for password leave it blank.
for example

also you can:

  1. take a learnable course, they are associated w/sitepoint. So i’d
    imagine they must be good.
  2. look up in youtube how to install wp
  3. take a quick lynda course on how to install wp.
  4. have someone install it for you.

I realize it can be a frustrating experience.
Good luck.

The default database password for MAMP is root, not empty (no password)

As pdxSherpa notes, as with WAMP, XAMPP is also no password as the default database password.

It doesn’t matter if you use XAMP, MAMP or anything. Installing WordPress shouldn’t change the password of your toot account. You provide the user and passwaord to connect to the database in the installation process.

If your root user needs no password, then that field should have been left blank.

Does restoring the computer to an earlier stage work?