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
