I have looked at the settings a great number of times but run into the same issue. When connected to my Linux box with the 'exact' same settings, no fault. When run on a fresh machine with xampp for testing:

SQLSTATE[28000] [1045] Access denied for user 'user'@'localhost' (using password: YES)

I'm positive the user name, privileges and password are the same so anything else I could be missing?

  • The user is @'localhost' on both computers? – DerfK Apr 7 '11 at 21:11
  • the user is technically defined as user@% so yes - I also have the same setup running on another windows machine and it works. Just so happens to occur on a fresh laptop install – JM4 Apr 7 '11 at 21:14
  • @DerfK - note, when I specifically state host as "localhost" in my mysql (I use navicat) configuration, it works, when I use the wildcard % it does not (even though the error above clearly shows it is trying to connect to the localhost hostname – JM4 Apr 7 '11 at 21:17
  • and this only works on one of the databases, not the other – JM4 Apr 7 '11 at 21:21

Probably you have skip-name-resolve option turned on.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.