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