Re: Problem revoking all privileges

I appreciate your attempt to get me to RTM, but I think you'll find the user@host syntax is correct.  It works if I list a specific privilege to revoke.

The problem is that ALL is itself a specific privilege.  You can grant/revoke using it but it doesn't replace all the other specific privileges - it's just another one and happens to mean everything.  I can grant/revoke ALL, but it leaves all those other specific privileges intact.

As far as I see it, the problem lies with how to remove all those specific privileges easily.  I can blindly list all privs to remove, but this is not ideal.  I suppose I could export host_privs, do some jigery-pokery with sed/awk and formulate all the possible privs to remove, but that just seems too long-winded.

I hope this explains the problem better,

Thanks,
Steve :)