MySQL Forums
Forum List  »  Newbie

Re: Corrupt mysql.users How to fix
Posted by: Peter Brawley
Date: November 03, 2016 08:19PM

In one cmd window ...

mysqld –-console –-skip-grant-tables –-skip-external-locking

In another ...

mysqlcheck –repair mysql user

If that fails, you may have to restore the mysql db from a backup.

After whichever method fixes the issue, issue mysqladmin shutdown and restart the mysql server normally.

Options: ReplyQuote


Subject
Written By
Posted
November 03, 2016 08:08PM
Re: Corrupt mysql.users How to fix
November 03, 2016 08:19PM


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.