Author Topic: MySQL root Password problem (not forgotton)  (Read 1249 times)

0 Members and 1 Guest are viewing this topic.

Offline Brian WTopic starter

  • Devotee
  • Posts: 864
  • Gender: Male
  • *face > palm *sip coffee
    • View Profile
MySQL root Password problem (not forgotton)
« on: February 04, 2010, 05:23:49 AM »
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 [
Quote
Warning] Changed Limits: ...
I found a new method using skip-grant-table which allowed me to get in and run
Quote
UPDATE mysql.user SET Password=PASSWORD('MyPassword') WHERE User='root'
which responds
Quote
Query OK, 0 rows affected (0.00 sec )
Rows Matched: 1 Changed: 0 Warnings: 0
Then I've even ran
Quote
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
Onto Web Development


Code Blog NEW!
Unsolicited commercial email will be read at a cost of $500 per message. Use of my email address implies consent to these terms.

Offline jskywalker

  • Enthusiast
  • Posts: 289
  • Gender: Male
    • View Profile
Re: MySQL root Password problem (not forgotton)
« Reply #1 on: July 10, 2010, 06:24:25 AM »
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......