root user without privileges?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

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

[ Data ]


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

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


Re: root user without privileges? wrote:
Quoted text here. Click to load it

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

Bill K.

Site Timeline