Menu
▾
▴
#2320 (ok 2.9.2) Deleting user with GRANT option fails
Deleting a user that has the GRANT option set via the "Remove selected users" option fails because the GRANT option is not unset with a REVOKE ALL PRIVILEGES.
This can f.e. be observed when trying to remove the root@thishost user.
The used query
REVOKE ALL PRIVILEGES ON * . * FROM 'user'@ 'hostname';
DROP USER 'user'@ 'hostname';
is insufficient. Adding a
REVOKE GRANT OPTION ON * . * FROM 'user'@ 'hostname';
before the DROP USER should fix this.
Logged In: YES
user_id=210714
Originator: NO
Which MySQL version are you using?
Logged In: YES
user_id=1585413
Originator: YES
Sorry I didn't mention this:
mysql-4.1.20-1.RHEL4.1 (CentOS 4)
Logged In: YES
user_id=210714
Originator: NO
Fixed for 2.9.2