aprilchelley — 2010-04-22T10:27:36-04:00 — #1
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.
crmalibu — 2010-04-22T12:16:32-04:00 — #2
Try logging in from the command line like this, assuming your username is "root"
mysql -u root -p
It should prompt you for the password.
aprilchelley — 2010-04-22T14:27:07-04:00 — #3
Ahh I finally fixed it..I ran the cmd for -skip-grant-tables, reset the password, but the only problem I have now is, after done all that, closed out all the prompts, I go back into Admin -> Services and try to run MySQL, it doesn't run unless I goto my task manager and end the process mysqld.exe. After that, MySQL in Services will work, but when I try to reconfigure the password in MySQL Server Reconfiguration, I get the "Access Denied for 'root'@'localhost'.
Btw, I'm using MySQL Server 5.1
Any other ideas?