List:General Discussion« Previous MessageNext Message »
From:Jigal van Hemert Date:March 10 2005 3:56pm
Subject:Re: Revoke all privileges on *.* doesn't work
View as plain text  
From: "Nico Sabbi"
> mysql> show grants for user3;
> +-----------------------------------+
> | Grants for user3@%                |
> +-----------------------------------+
> | GRANT USAGE ON *.* TO 'user3'@'%' |
> +-----------------------------------+
> 1 row in set (0.00 sec)
> 
> what am I doing wrong?

You're not reading carefully ;-P
Look at the table at http://dev.mysql.com/doc/mysql/en/grant.html

Near the bottom it says:
USAGE   ||    Synonym for ``no privileges''

So, you succesfully removed all privileges!

Regards, Jigal.
Thread
Revoke all privileges on *.* doesn't workNico Sabbi10 Mar
  • Re: Revoke all privileges on *.* doesn't workJigal van Hemert10 Mar
  • Re: Revoke all privileges on *.* doesn't workSGreen10 Mar
RE: Revoke all privileges on *.* doesn't workChristian Caron10 Mar
  • Re: Revoke all privileges on *.* doesn't workNico Sabbi10 Mar
    • MAX_JOIN_SIZE error. 4.0 v 4.1Brett Harvey10 Mar
      • Re: MAX_JOIN_SIZE error. 4.0 v 4.1SGreen10 Mar
      • Re: MAX_JOIN_SIZE error. 4.0 v 4.1Sergei Golubchik10 Mar
RE: Revoke all privileges on *.* doesn't workPaul DuBois10 Mar