How To Recover The Lost Privileges If All User Accounts Have Lost Or Lack Necessary Privileges (Doc ID 2589350.1)

Last updated on JULY 03, 2022

Applies to:

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

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