MySQL 5.6 question about revoking an active session
Posted on 2014-02-28
So far I experimented on a MySQL 5.6 server
grant all on *.* to 'myuser'@'%' with grant option;
all worked fine. I then tried from myuser's account to kill another session one of the su
per only privileges and it let me so obviously when you grant all on *.* it also grants super privileges but I assume that would be only if *.* (Global) was used
Now I then tried:
revoke super on *.* from 'myuser'@'%' ;
I then for safe measure:
go back to my live session and try to kill another session and I can still kill others session
so my question here would be why don't the revokes take immediately
I could kill the active user but that seems a schlocky solution:
Any way to do this revoke on active sessions???
I did find the super privilege was revoked upon reconnect but what about live connections??