0

I am using MAMP.

It seems that when I tried making some changes with the passwords, I messed it up and now I can't access anything on phpMyAdmin.

I've tried to reinstall MAMP, but all I get is still the same error.

Does anybody know how to fix this?

enter image description here

UPDATE: Even in terminal I get the same error

/Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Improve this question
1
  • Please post textual error messages as text, not as illegible screenshots. Commented Sep 24, 2013 at 14:54

2 Answers 2

Reset to default
2

check your configuration file in MAMP, the password isn't defined

The reinstallation doesnt rewrite conf files

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

I checked the conf file, and I thought that the password is set to root, since it says: $cfg['Servers'][$i]['password'] = 'root'; Was I wrong?
Since the problem also occurs from the command-line client, this seems unlikely.
1

Try resetting your root password via the console. Instructions can be found here.

The instructions cover Windows and *Nix.

The reason why when you re-installed MAMP/WAMP/LAMP/MySQL etc and it doesn't remove the password is because it saves the config files, and when you remove MySQL it doesn't delete the config files relating to the passwords. I've had this issue on Windows and Linux - But I can see it affects Mac's too.

Edit: I am assuming you have console access, because you mention MAMP - If you don't, try your host' control panel, it will have an option for Mysql there.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.