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)
--
-------------------------------------------------------------
Scott Haneda Tel: 415.898.2602
<http://www.newgeo.com> Novato, CA U.S.A.
