MySQL Forums
Forum List  »  Newbie

Forgot Root Password
Posted by: Aaron Harker
Date: November 26, 2015 10:24PM

First let me say sorry if I've posted this to the wrong board but it is such a noobish thing to do I figured it deserved to be here.

I have forgotten my root password.

I have tried using the init.txt file method and the old --skip-grant-tables method with the same result from both.

ERROR 1131 You are logged on as an anonymous user and anonymous users are not allowed to change passwords

When using --skip-grant-tables method after running the FLUSH PRIVILEGES command I get Query OK, 0 rows affected

Also if I just try to update the user table I get

ERROR 1054 Unknown column 'password' in 'field list'

I am running version 5.7.9(32-bit) on Windows Server 2012 Foundation.

Anyone have any ideas?

Options: ReplyQuote


Subject
Written By
Posted
Forgot Root Password
November 26, 2015 10:24PM
November 26, 2015 10:37PM
November 26, 2015 11:11PM
November 26, 2015 11:02PM
November 26, 2015 11:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.