Admin Error

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

Threaded View
OK, I mucked up...

My ROOT user has NO priviliges on ANY table... I, however only have
INSERT and SELECT priviliges on the MYSQL table and SELECT on other
tables... Can I create a new user that can then fix ROOT?


Re: Admin Error

Read this:

I couldn't explain it any better ;-).


Re: Admin Error

Hmmm, that page talks about resetting PASSWORDS not permissions.. I
KNOW the password, it's just that user ROOT has NO permissions.


Re: Admin Error

In that case, do it with

grant all on *.* to root@localhost with grant option;

This gives user root all privileges on all databases.

Maybe you have to replace localhost with more specific entries, if they are
defined so.


Site Timeline