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