List:General Discussion« Previous MessageNext Message »
From:Scott Haneda Date:September 2 2005 4:49am
Subject:Trouble with revoke all
View as plain text  
Mysql 4.0.18-standard

revoke all on *.* from 'deleteatanytime'@'localhost';

mysql> revoke all on *.* from 'deleteatanytime'@'localhost';
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
mysql> revoke all on *.* from deleteatanytime@localhost;
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

I am ssh'd int the box, so I am localhost, I am root, and it just does not
want to let me remove access privs, in this case, all I have is select
privs.  For the longest time I just delete the user and recreate the
permissions, but I would like to figure out how to make this work.

-- 
-------------------------------------------------------------
Scott Haneda                                Tel: 415.898.2602
<http://www.newgeo.com>                     Novato, CA U.S.A.


Thread
Trouble with revoke allScott Haneda2 Sep
  • Re: Trouble with revoke allGleb Paharenko2 Sep
    • Re: Trouble with revoke allScott Haneda2 Sep
      • Re: Trouble with revoke allMichael Stassen2 Sep
        • Re: Trouble with revoke allScott Haneda3 Sep
          • Re: Trouble with revoke allMichael Stassen3 Sep
            • Re: Trouble with revoke allScott Haneda3 Sep
              • Multiple query execution (probably OT)Alvaro Cobo3 Sep
                • Re: Multiple query execution (probably OT)Gleb Paharenko3 Sep
                • How to migrate from V4.0.23 to V5?Siegfried Heintze4 Sep
                  • Re: How to migrate from V4.0.23 to V5?Gleb Paharenko5 Sep
      • Re: Trouble with revoke allGleb Paharenko2 Sep
        • Re: Trouble with revoke allScott Haneda3 Sep
    • 2 query questionsYL2 Sep
      • Re: 2 query questionsJason Pyeron2 Sep
      • Re: 2 query questionsSGreen2 Sep
        • string->array question. ( 2 query questions)YL3 Sep
          • Re: string->array question. ( 2 query questions)Peter Brawley3 Sep
        • Re: string->array question. ( 2 query questions)YL3 Sep
          • Re: string->array question. ( 2 query questions)Peter Brawley3 Sep