Resetting your wordpress admin password.

== For Command Line MySQL ===

You might have direct access to your MySQL database from the command line. Usually this is done by sitting at your server, connecting directly to your server via SSH, or using the MySQL client on your workstation to connect to your server. You must be in the correct context to successfully execute the mysql command mentioned below.

To reset your WordPress password from the MySQL command line, do the following (replace the options in italics with your settings):

  1. “mysql -u root -p” (Logs in to MySQL)
  2. Enter your password at the prompt.
  3. “use name-of-database” (Selects your WordPress database)
  4. “show tables LIKE ‘%users’;” (Finds the WordPress user table)
  5. “SELECT ID, user_login, user_pass FROM name-of-table-you-found WHERE user_login = ‘username‘;” (Observe the encrypted password)
  6. “UPDATE name-of-table-you-found SET user_pass=MD5(‘new-unencrypted-password‘) WHERE user_login = ‘username‘;” (Updates the database with the encrypted password)
  7. “SELECT ID, user_login, user_pass FROM name-of-table-you-found WHERE user_login = ‘username‘;” (Confirm that it was changed)
  8. “exit” (Exits the MySQL client)
  9. Login to WordPress using the username and password that you’ve altered.
Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s