1

I recently setup a MySQL server and encounted the following error when I ran the mysql console (and incidentally the administrator GUI tool):

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

I had done a standard installation and reached the last page in the configuration wizard when the security check stage failed with an error suggesting that the MySQL port was blocked by a firewall.

closed the wizard, checked there was no firewall running and then and tried running mysql and the administrator GUI and found the same error in both cases.

Can anyone suggest a solution to the problem or perhaps resources for diagnosing MySQL problems.

1

You may need to reset your root password. I had a similar problem a while back.

Details: How to reset the root password

The basic process involves stopping the server and restarting it with a special initialization script.

  • Thanks, this worked perfectly. I do wonder what the installer did to incorrectly set the root password. I would blame myself using the wrong password, but it actually failed from the config wizard where you set the thing. – RedBlueThing May 1 '09 at 5:20
0

1045 is generally "access denied". See the MySQL documentation for suggestions about how to deal with this.

  • Heh, I noticed that 1045 mapped to "access denied" when I read the message "ERROR 1045: Access denied ...". – RedBlueThing May 1 '09 at 3:13
0

I faced this error and many people on internet and even on stackoverflow recommended to reinstall the MySQL but in my opinion, you should not reinstall the MySQL and can solve this issue with few simple commands. Please follow this URL: https://www.windowstechupdates.com/error-1045-28000-access-denied-for-user-username-using-password-yes/

  • azharalibuttar, welcome to SF! We tend not to like link-only answers around here, because the links rot, and then the answers are useless. Having skimmed the linked article, I think you might have the makings of a useful answer here; if you were to expand your answer to include the most important elements of the linked article (and keep the link), I'd upvote it. – MadHatter Sep 8 '16 at 6:40

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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