Weird behavior after deleting (!) accounts
Posted by: Denis Brooker
Date: June 29, 2017 02:34PM

There were quite a few accounts on our MySQL database that started with (!). The explanation was "<account> does not exist but it still has privileges defined for the following objects:” Based on the information given and another post in the forum that said "The message you get comes from the fact that there are grants for a user which no longer exists. So it makes sense to remove those grants.” However, when I removed the account, it affected an active user (another account) by removing the grants for that user. The two accounts (the deleted one and the active one) had the same name but were different accounts from two different hosts. Has anyone seen this behavior before?

Options: ReplyQuote


Subject
Written By
Posted
Weird behavior after deleting (!) accounts
June 29, 2017 02:34PM


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.