The following statement is working as expected
开发者_开发问答grant all on *.* to 'foo'@'10.10.%' identified by 'bar';
But I want to grant all privileges except "super" privilege. I wish there was "grant all except super" syntax!
would revoking the privilege immediately afterwards not do the trick?
Something like
revoke super on *.* from 'foo'@'10.10.%';
精彩评论