Bug #98276 delete user from mysql.user table don`t drop user
Submitted: 17 Jan 2020 16:35 Modified: 17 Jan 2020 20:17
Reporter: mohamed atef Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.7 OS:Windows
Assigned to: CPU Architecture:Any

[17 Jan 2020 16:35] mohamed atef 
Description:
when delete specific user from mysql.user table the user is still working

How to repeat:
open workbench connection 1 with user root then add new user

CREATE USER IF NOT EXISTS 'admin'@'%' IDENTIFIED WITH mysql_native_password BY 'admin' PASSWORD EXPIRE NEVER;
grant all privileges on *.* to 'admin'@'%' with grant option;

then open connection2 with user admin

in connection1 execute select * from mysql.user

then select admin and delete the record

in connection2 user admin still working
[17 Jan 2020 20:17] MySQL Verification Team 
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

https://bugs.mysql.com/bug.php?id=98275