Host 'localhost' is not allowed to connect to this MySQL

[geraldgrogan]

I acidentally revoked all users privilages (instead of granting all access - having a very bad day ) and now I am getting the following error message at the command line:

mysqladmin -u root flush-privileges password "newpass"
'Host 'localhost' is not allowed to connect to this MySQL server'

**Any ideas how I can gain access to this database on a Windows XP machine?

[mammut]

you have to stop mysql
then start it with the option "--skip-grant-tables"
With this option you achieve that the tables for the rights are not read at start of mysql.
start mysql
then you can delete the crypted password for root.
stop it again and start mysql without this option.
Now you can give root a new password.
I hope this will help you. I did not test it.