I installed MySQL Server 5.1, set a password and all was working well. I was messing around in Navicat with the Databases and somehow I messed everything up, and it all went downhill from there.

I've tried following every instruction available but I keep getting Error Nr. 1044 and 1045. If I try to reset the password using the Command Prompt (followed from a tutorial) I keep getting the Access denied for "@'localhost' to 'mysql'. I've tried flushing privileges, resetting the password. I've tried everything imaginable. I read somewhere that "@'localhost' means anonymous user, so how would I set the user back to root? I'm completed inexperienced with MySQL, and how I got it working in the first place is beyond me. If someone could help I'd really appreciate it.

Delete the installation and re-install it. Write the passwords down

_________________
Lostboy

Cat, the other other white meat

Please read Posting Etiquette before posting

You can always try Google