root user without privileges?

root user without privileges?

am 18.09.2006 14:42:26 von menoquindici

We have a situation here where one of my co-workers removed several
privileges from the 'root' user, namely:

[ Data ]

INSERT
UPDATE
DELETE
FILE


Now, every time I enter with the root user and try to re-activate these
privileges I get:

#1045 - Access denied for user 'root'@'localhost' (using password: YES)



If I try to modify the privileges by editing the 'user' table of the
'mysql' database I get:

#1142 - UPDATE command denied to user 'root'@'localhost' for table
'user'


How can we restore all the privileges to the root user in such
condition without reinstalling MySql?


thanks!

Re: root user without privileges?

am 18.09.2006 19:54:26 von Bill Karwin

menoquindici@luca.su wrote:
> We have a situation here where one of my co-workers removed several
> privileges from the 'root' user, ...

You can do a lot to restore privileges by following steps documented here:

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions .html

Regards,
Bill K.