WordPress Development Stack Exchange is a question and answer site for WordPress developers and 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

I gave my client the admin account to his wordpress install and I forgot to add an administrator user for myself. Now, I can no longer access the admin panel because they have changed their password. I have direct access to the database and was wondering if I could inject a new admin user via SQL?

share|improve this question
Ask the client to add an admin account for you? Why do you need to inject data if you are permitted to access this site's database, or you own the server. – t31os Nov 29 '11 at 14:44
As I mentioned, I don't want to bother my client. Also, by "inject" I meant writing SQL directly to the DB. – Brian Wigginton Nov 29 '11 at 22:32
Mentioned where? ... I think the answer you have from patnz covers it(everything you need)... just strikes me as a little strange is all.. – t31os Nov 29 '11 at 22:53
My bad, thought I mentioned it but must have all been in my head... sorry about that. – Brian Wigginton Nov 29 '11 at 23:02
I do that to... no worries.. ;) – t31os Nov 29 '11 at 23:20

Pretty easy to do from phpMyadmin. I've used this tutorial before successfully.

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.