root user without privileges?
am 18.09.2006 14:42:26 von menoquindiciWe 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!