MySQL root Password problem (not forgotton)

[Brian W]

Windows Server 2007, MySQL 5.1

 

I installed MySQL several days ago, 3 days ago I tried signing in as root@localhost and I was denied using the same password I had used before. I found some help on resetting my password via init-file which worked. Again, yesterday the same password again stopped working. I tried the same technique with init-file to reset the root password, but I get a message [

Warning] Changed Limits: ...

I found a new method using skip-grant-table which allowed me to get in and run

UPDATE mysql.user SET Password=PASSWORD('MyPassword') WHERE User='root'

which responds

Query OK, 0 rows affected (0.00 sec )

Rows Matched: 1 Changed: 0 Warnings: 0

Then I've even ran

flush privileges;

 

In CMD: "NET Stop MySQL"

In CMD: "NET Start MySQL" **this time without skip-grant-table

 

For my example, I would expect to be able to sign in using password "MyPassword", but IT DOESN'T, I'm denied.

 

Please advise

[jskywalker]

changing you password should not give this result:

Rows Matched: 1 Changed: 0 Warnings: 0

 

But is should give this result:

Rows Matched: 1 Changed: 1 Warnings: 0

 

There seems to be no user 'root' in your mysql.user table......