MySQL: can't access root account

Question

I'm running MySQL 5.x on my local Windows box and, using MySQL administrator, I can't connect to the databases I created using the root account. The error I get is:

MySQL Error number 1045 Access denied for user 'root'@'localhost' (using password: YES)

I can't recall changing root account credentials, but I know I tried to give other computers on the LAN access to the db by adding their IPs. One thing I did for one of the IPs was to specify access to the account 'root' instead of root, i.e. I surrounded root with single quotation chars. All using MySQL administrator. Could this be the reason why i can't login using root?

Also, is there a way to create a new or reset the root account? As previously mentioned, I have full access to my box.

See these questions

• How to change MySQL root password to default?
• How do I retrieve my MySQL username and password?
• How do I change the password of the root user in MySQL?

Answer 1

Here is how to reset the password: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

Answer 2

There is a section in the MySQL manual on how to reset the root password which will solve your problem.

Answer 3

I've tried several ways of reseting the password (including this), but it doesn't work. is it possible to create another root account?