Creating a New Admint Username? (7 posts)

  1. aletheides
    Posted 7 years ago #

    Recently I've had a problem with my admin username coming up invalid.

    I checked the tables in PHPmyadmin and found out that the admin username had somehow been deleted.

    Is there any way to recreate the username with administration permissions through PHPmyadmin or some other method?

    Best regards,

  2. Khairil Zhafri
    Posted 7 years ago #

    Because we do not know what exactly been deleted, what I can suggest is to install another WP instance. Then compare both database table especially user and usermeta. Just copy entries in the fresh WP install to the old one.

  3. whooami
    Posted 7 years ago #

    yes, the same way you saw it was deleted, only this time you just add back the data..

    (that link is in that other post)

    The passwd that is stored in the databse is actually an md5 of a plain text word, so use this:


    put in your plain text password

    the resulting hash is what goes into the passwd field in the table.

  4. whooami
    Posted 7 years ago #

    and he/she knows whats deleted :) he/she looked at it because of another post..

    that image that I pointed you to in the other thread pretty much shows you what ought to be there, aletheides. Its easier than you think.

    If it looks incomplete, just post a screenshot, and i will give you a mysql query to add back the stuff thats missing.

  5. Khairil Zhafri
    Posted 7 years ago #

    I dont think it's safe to use the md5 utility to put your password.

    If you forgot the password, just use "forget password" in wp-login.php.

  6. whooami
    Posted 7 years ago #

    well poppacket, I can tell you from having been using WP for over three years, that it is safe. Futhermore, you havent been following this thread very well or you would know that the OP isnt having a problem that is solved by your suggestion.

  7. Khairil Zhafri
    Posted 7 years ago #

    Well, since you know better, whatever.

    I just said, "I dont think...".

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.