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.

RedBlueThing
  • 137
  • 1
  • 3
  • 8
  • MySQL 1045 is explained here: http://www.webyog.com/faq/content/23/18/en/error-no-1045-connection-denied.html – Ashwin A Aug 10 '12 at 12:14

2 Answers2

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.

Steven Richards
  • 136
  • 1
  • 3
  • 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 01 '09 at 05:20
0

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

Tony Meyer
  • 889
  • 1
  • 13
  • 25