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