Skip to content

Howto reset wordpress passwords

January 30, 2007
 Through MySQL Command Line

   1. Get an MD5 hash of your password.
          * Visit MD5 Hasher (, or...
          * Create a key with Python. or...
          * On Unix: echo -n  | md5sum
   2. "mysql -u root -p" (log in to MySQL)
   3. enter your mysql password
   4. "use (name-of-database)" (select WordPress database)
   5. "show tables;" (you're looking for a table name with "users" at the end)
   6. "SELECT ID, user_login, user_pass FROM (name-of-table-you-found)" (this gives you an idea of what's going on inside)
   7. "UPDATE (name-of-table-you-found) SET user_pass="(MD5-string-you-made)" WHERE ID = (id#-of-account-you-are-reseting-password-for)" (actually changes the password)
   8. "SELECT ID, user_login, user_pass FROM (name-of-table-you-found)" (confirm that it was changed)
   9. (type Control-D, to exit mysql client)

From → howto

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: