How To Reset WordPress User Passwords

programming 3173456 640 1

WordPress is arguably the most popular content management system in used today. With new users and students using it to blog and manage websites, there are some tips and tricks that may be useful for them to use, like resetting forgotten passwords.

This brief post shows users how to change forgotten passwords in WordPress. If one forgets his or her password, there are many ways to recover or reset it. However, some hosts prevent the use of mail() function or the users with forgotten password may not have access to the email address associated with his/her account.

In you find yourself in similar situations, follow the steps below to learn how to easily reset forgotten WordPress passwords.

Step 1: Reset Password from WordPress Admin Dashboard

One way users can reset their password in WordPress is from the admin dashboard. This only works if the user(s) have access to WordPress admin area. A user can reset his/her password by logging in to his/her account and going to Dashboard –>  Profile –> and selecting his/her account and generating new password under Account Management.

wordpress reset password

Step 2: Resetting Forgotten Password

User can reset forgotten passwords from the logon page. Just click the Log your password? link to reset. For this to work, your host must enable mail() function and the email address for the user must be valid and accessible. Without those two things, the method will not work.

wordpress password reset

Step 3: Reset Password using phpMyAdmin (cPanel)

Another way one can reset his/her password is via phpMyAdmin via cPanel. Most hosts provide cPanel access to users to manage their domain and content. To reset WordPress password via phpMyAdmin, logon to cPanel or directly to phpMyAdmin.

Then navigate to the Database section and select phpMyAdmin

wordpress cpanel myql backup

When it opens, select and expand the WordPress database and click the wp_users table. This should list the users. Next to the user with lost password, select the Edit link.

wordpress reset password cpanel

On the next page, find the user_pass column, change the Function to MD5 and type a new password in the value field and click Go.

wordpress reset password

When you click Go. it should update the password table with the new one.

Step 4: Resetting WordPress Password from MySQL

Another way to reset one’s WordPress password is using MySQL or MariaDB SQL command. Run the commands below to logon to the database.

sudo mysql -u root -p

Then run the commands below to select WordPress database named wpdb. change it to what you named your WordPress.

use wpdb;

Run the commands below to change the password for the user named demo. change the name to what you called it.

UPDATE wp_users SET user_pass = MD5('new_password_here') WHERE user_login = demo;

This should change the password for the username demo.

That’s it!


You may also like this post:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.