List:General Discussion« Previous MessageNext Message »
From:Scott Haneda Date:September 2 2005 11:14pm
Subject:Re: Trouble with revoke all
View as plain text  
on 9/2/05 4:10 PM, Michael Stassen at Michael.Stassen@stripped wrote:

> So root@localhost is missing something (you can't GRANT a privilege you
> don't have).  In that case, I think you need to do as Gleb suggested.  Shut
> down mysqld, then start it with --skip-grant-tables and reissue
> 
>    GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
> 
> then stop and start the server again.

I take it my uptime value is going back to zero :-)

> Alternatively, you could try to do this witout stopping mysqld.  UPDATE
> root@localhost's row in the mysql.user table to have the correct values,
> then FLUSH PRIVILEGES (but I'm suspicious something like that is how this
> started).

I never fiddle direct like that, but there was that fix_privs_table script
mysql provided I had to run at one time during an update.
-- 
-------------------------------------------------------------
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