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
