How To Recover The Lost Privileges If All User Accounts Have Lost Or Lack Necessary Privileges
(Doc ID 2589350.1)
Last updated on MARCH 12, 2021
Applies to:MySQL Server - Version 5.5 and later
Information in this document applies to any platform.
The privileges granted to a MySQL user account determine which operations the account can perform. If all of privileges for super user(s) such as 'root' were lost accidentally, e.g. using " REVOKE ALL PRIVILEGES, GRANT OPTION FROM ... " statement, the user account(s) would not be allowed to perform any necessary operations, such as SELECT, UPDATE, CREATE, ALTER, GRANT, ... etc.
This document introduces a method to recover lost privileges for a super user if all users have lost or lack necessary privileges.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document