Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
2  
possible duplicate of Completely reset mysql server authentication –  Zoredache Jun 9 '10 at 5:58
2  
    
Thanks for the help! –  PJ. Jun 9 '10 at 15:37
add comment

1 Answer

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 http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html.

share|improve this answer
add comment

Your Answer

 
discard

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.