I have Mysql 4.1 running as service on Win2k.

I cannot access the user database.

I have changed my root password.

I followed the instructions from the manual below.

;C:\> C:\mysql\bin\mysql mysql

;mysql> DELETE FROM user WHERE Host='localhost' AND User='';

;mysql> QUIT

;C:\> C:\mysql\bin\mysqladmin reload

;C:\> C:\mysql\bin\mysqladmin -u root password your_password

I tried to invoke first line "mysql mysql". Access denied.

I was able to delete from user.

I specified the Password.

I even called Mysqladmin and my password worked for it.

After that, i'm stumped.

I can't access the user database. I thought "user root" was the superuser here.

What am I doing wrong? Since I deleted the localhost and anonymous user should I not be actually logged in as User Root?