List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:September 2 2005 8:27am
Subject:Re: Trouble with revoke all
View as plain text  
Hello.

> 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

Recreate grants for the 'root'@'localhost' user manually. For this
purpose restart server with --skip-grant-tables command line options
and modify the grant tables. See:
  http://dev.mysql.com/doc/mysql/en/resetting-permissions.html
	http://dev.mysql.com/doc/mysql/en/privileges.html


> Mysql 4.0.18-standard

Your version of MySQL is rather old, I recommend you to upgrade to the
latest release (use 4.1.14 or 4.0.25).


Scott Haneda <lists@stripped> wrote:
> 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.
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



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