Twinkletoes <[EMAIL PROTECTED]> 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 > (recursing into table/columns etc.) ? > > Many thanks, > Steve :) > -- > View this message in context: http://www.nabble.com/Problem- > revoking-all-privileges-t1183423.html#a3115859 > Sent from the MySQL - General forum at Nabble.com. > >
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