How to reset WordPress Password through PHPMyAdmin or MySQL CLI

Описание: This video shows you two ways to reset your WordPress password if you've been locked out of your account.

Always take a database backup before doing any database operations.

Step 1:
Locate and find your wp-config.php file for your WordPress installation. This can be locally or on your server (through File Manager or FTP). Open it up and view the contents.

Note the database name, database user, database password, and wp_prefix. This information will be used in later steps.

Method 1: PHPMyAdmin

1) Log into phpmyadmin and find the database table from wp-config.php and click on that database name on the left side.

2) Find the wp_users (or similar) table and click on it.

3) Edit the row for the user you want to change the password.

4) Next to user_pass field, select md5 in the dropdown and erase the contents on the right of the dropdown. Type your new password here.

5) Hit go.

6) Your password has been changed and you can now log in.

Method 2: MySQL CLI

1) SSH into your server or open a terminal if your WordPress installation is local.
2) Type "mysql -u yourusername -p" (without the quotes, replacing yourusername with your actual database user from wp-config.php). Hit enter.
3) Type "USE databasename;" (without the quotes, replacing database name with the name of your database from wp-config.php)
4) If it says "database changed", proceed. If it does not, find the correct name of your database and try again.
5) Once in the database, type the following query without the double quotes into your terminal:

UPDATE wp_users SET user_pass = MD5('yournewpassword') WHERE user_login = 'youraccountlogin';

(wp_users may be different, depending on the $wp_prefix value from wp-config.php. Replace yournewpassword here with your actual new password, keeping the single quotes in place. youraccountlogin should be replaced with the username you're using to log into wordpress with.)

You can also do it by email address if you only remember your login email. That query would look like this:

UPDATE wp_users SET user_pass = MD5('yournewpassword') WHERE user_email = '[email protected]';

(replace [email protected] with your actual email address, keeping the single quotes)

Don't forget the ending semi colon. If you do forget it, mysql will present you with a new prompt where you can just type ";" without the quotes and hit enter.

Hope this helps! Leave me any questions or comments below.

How to FTP:
   • How To Use FTP  

How to SSH on Windows:
   • How To SSH On Windows