on 9/2/05 1:27 AM, Gleb Paharenko at [EMAIL PROTECTED] 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? -- ------------------------------------------------------------- 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]