Setting up a new user in phpMyAdmin

  • Resolved jacksonsky

    (@jacksonsky)


    6 years, 7 months ago

    After transferring a site from one host to another, I’ve been locked out of WordPress (which seems unusual, since usually all the users transfer without an issue). I tried changing the existing user password via phpMyAdmin and it’s still not accepting the new one. Any ideas what might be causing this?

    I also tried creating a new user, but when I did, the permission levels don’t get assigned, so upon signing in, I have an admin bar with the option to view my profile or log out.

    Has this happened to anyone else (being unable to change a password in phpMyAdmin)? Or, is there a table row in phpMyAdmin where I can change the user setting to administrator?

    Thanks in advance!

Viewing 3 replies - 1 through 3 (of 3 total)

  • You can change the password in wp_users table, but you have to use md5 hashing while storing the password from editing the row and choose md5 in function from the dropdown list before filling new password.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    with pictures…. This article lists 7 completely different ways to reset your password. Any one of them will work and do the job. Find the one that’s right for you and use that: https://codex.www.ads-software.com/Resetting_Your_Password

    Thread Starter jacksonsky

    (@jacksonsky)

    Thanks for the replies. I was able to reset the password by simply changing the email address from the administrator account to mine (via phpMyadmin), and sending an password change request. I’d still like to know how to create new users on a phpMyAdmin level, but I’ll save that for another day.

    • This reply was modified 6 years, 7 months ago by jacksonsky.
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Setting up a new user in phpMyAdmin’ is closed to new replies.