CODEWITHSUNDEEP
mysqlwordpressphpmyadminmampmysql-error-1045
bibliofille
bibliofille

Reputation: 11

#1045 - Access denied for user 'root'@'localhost' (using password: YES) MAMP MySQL access denied

I'm trying to copy a live WordPress site to my local server. I went to import the database from the live site through MAMP, and I received an error message when trying to connect to phpMyAdmin:

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

I have a couple local WP installations running already, and I'm able to access them through the localhost:8888/sitename path just fine.

I haven't changed any passwords or messed around with any configurations in phpMyAdmin. In fact, it was all working fine just yesterday. I had to re-boot my computer because it froze on me this morning, and that's when the issues began.

I even went into the config.inc.php file in Applications/MAMP/phpMyAdmin, and the usernames and passwords match what I had originally. (It definitely wasn't 'YES')

I'm stumped at this point. Could anyone help?

Upvotes: 0

Views: 8620

Answers (3)

Kiriakos Grhgoriadhs
Kiriakos Grhgoriadhs

Reputation: 319

Try to use single quotes in password, cause the symbol $ inside double quotes is like aphp variable

Upvotes: 0

user2030856
user2030856

Reputation: 77

change the password to a more basic form. for example i had "!@#$]#$%^%&^" i changed it to "mypassword1" and it worked. It is a wordpress issues that it doesn't support weird characters.

Upvotes: -2

Nick
Nick

Reputation: 1863

Can you try resetting the MySQL server password using this guide. Then put the new password in the PHPMyAdmin config?

using password: YES Means that you attempted to login using a password, not that the password used is 'YES' Its referring to the different options for logins like certificates etc.

Upvotes: 0

Related Questions