Re: Problem revoking all privileges

Twinkletoes <nabble@...> wrote on 02/24/2006 04:18:18 PM:

>
> I'm using MySQL 4.1 (I think... a late 4 anyway) on a Gentoo box.  It's
only
> a semi-live situation and no need for security just yet.
>
> After messing with privileges a bit, I decided to revoke whatever
privileges
> are already applied and specifically grant only the ones I need (using a
> shell script).  To revoke, the obvious choice was to use (if I can
remember
> it correctly):
>
> mysql> revoke ALL on *.* from '%'
>
> However, I'm getting an error about that privilege not applied, and I've
> read it's because ALL isn't an alias for all privileges, it's a
privilege in
> itself.  I think this is the reason I can't remove it!  So, the question
is,
> how can I revoke all the permissions that have been applied to a
database
If you had checked the manual, you would have seen that your statement's
syntax is missing the name of the user whose privileges you are trying to
revoke.

REVOKE ALL ON *.* FROM 'username'@'%';

is what you are looking for.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine