Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In attempts to learn more about apache and mysql, I've been fiddling with my local environment. Fun times. Of course, this leads to my screwing things up. So, thanks for being there.

Recently, I messed up a bit in mysql. I currently don't have a root user, and the users I do have don't have grant access. So, I can create users and all that, but I can't create a root user with super powers.

Besides removing and reinstalling mysql, is there a way to grant a user total access in my current situation?

share|improve this question
Just restore from your backup. – John Gardeniers Jun 9 '10 at 5:56
possible duplicate of Completely reset mysql server authentication – Zoredache Jun 9 '10 at 5:58
Thanks for the help! – PJ. Jun 9 '10 at 15:37
up vote 1 down vote accepted

There's no need to reinstall MySQL. You can just create a new root user and reset the permissions in MySQL as described in

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.