List:General Discussion« Previous MessageNext Message »
From:Michael Stassen Date:September 2 2005 11:10pm
Subject:Re: Trouble with revoke all
View as plain text  
Scott Haneda wrote:
> on 9/2/05 9:08 AM, Michael Stassen at Michael.Stassen@stripped wrote:
> 
> 
>>>Modify them how?
>>>show grants for 'root'@'localhost';
>>>GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN,
>>>PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, LOCK TABLES,
>>>EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'root'@'localhost'
>>>IDENTIFIED BY PASSWORD 'xxxxxxxxxxxx' WITH GRANT OPTION
>>>
>>>This looks pretty much full access to me?
>>
>>I didn't look closely to see if anything's missing in that list, but full
>>access usually looks like this:
>>
>>   GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD
>>   'xxxxxxxxxxxx' WITH GRANT OPTION
> 
> 
> And that is the odd thing, running that gives me:
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

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.

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).

Michael
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