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?