MySQL - Locked Out!

[vigiw]

Hello,

I am running MySQL on my home computer, a Windows XP Pro.  I am using Navicat and was changing users and permissions to secure the database--then, somehow I had a user with all privileges, and the rest without any, and this user connected to a no-ip.com address because I was trying something out, and it didn't work out so well.

Now I cannot login to any of the connections of the database...

So my question is, is there a way to undo this--or how do I create a new database or something on my PC so I can start over, this time, with a working connection?

Thanks!

[gluck]

You will find your answers here. You can start MySQL with ignoring the user tables.

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

[vigiw]

Hi gluck,

Thanks for your help!  ;D  Will this work if my host is wrong, like I said, and not local host?  That is the reason I cannot access..

If so, for the file including

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');

should I change localhost to my non-working no-ip.com host -- or if I type localhost, will it make it so I can access with localhost?


Thanks again!