My Oracle Support Banner

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.

Goal

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. 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.