can't login

Anon

I know very little about MySQL. I am using it because the forum that I run uses it...
Everything has been working fine for 3-4 weeks. I am doing this whole thing on a Windows 2000 Professional machine, on localhost (internally)... Today, all of the sudden, I can't get into mysql. My forums won't work (phpBB2):
"
phpBB : Critical Error

Could not connect to the database
"

In the command prompt, i try to do a mysqladmin -u root -p ping and after I enter the password I get
"
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
"

I never changed the password. Did something get corrupted? How can I get back in? I can do a bin> mysql and then >show databases; and the existing databases get listed, but I can't do anything else...

Please help.

Thank you very much!

flipis

Usually MySQL, when installed, creates a user without username or password. Try to access the database with no value on each of them. I had the same problem (althought i had changed the password by mistake), and did this, and it worked.

fLIPIS

Anon

Quickest way is to do the following:

Shutdown mysql.
Find the path to the mysql exec that is being run (look in Services ->Mysql -> properties).
Get a dos prompt command box up (use CMD).
Run <fullpath>\mysqld-nt.exe --skip-grant-tables. This starts mysql without any permissions being active.
Run mysql client (usually just mysql in the dos box).
Type "\u mysql"
Type "update user set password = password('<whatever you want the password to be>') where user = 'root';
Come out of mysql client.
Type mysqladmin shutdown (this stops mysql).
Go back into the services panel and start mysql normally. Your root password should now have been reset.

Cheers
Justin

Anon

Rincewind, I am grateful. I will try this when I get home tonight. After I do all this, can I retype/rechange/reset a password for the root user? Thanks again.

fLIPIS, I did set a password for the root user after I installed mysql. I can't get in without a password...