on 9/2/05 9:08 AM, Michael Stassen at [EMAIL PROTECTED] 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: '[EMAIL PROTECTED]' (Using password: YES) -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]