List:General Discussion« Previous MessageNext Message »
From:Michael Stassen Date:September 2 2005 4:08pm
Subject:Re: Trouble with revoke all
View as plain text  
Scott Haneda wrote:
> on 9/2/05 1:27 AM, Gleb Paharenko at gleb.paharenko@stripped wrote:
> 
> 
>>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
> 
> 
> 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

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