How to change WordPress password if you forget it?
Imagine that you forgot password yo your WordPress site and cannot login.
But still if you have access to cPanel of your hosting, then you can set new password.
To do this, login to cPanel and open PHP My Admin.
After that select database that belongs to your WordPress site.
If you have multiple WordPress sites in your hosting and you don’t know which one belongs to desired site.
In this case you can login to site by FTP and check content of file wp-config.php.
It should have string that defines database name, for example like this:
/** The name of the database for WordPress */
define( ‘DB_NAME’, ‘google_a2wp533’ );
Okey, when you opened desired database, you need to find table wp_users or wpy5_users in my case:
After that find row with corresponding user name and press link edit on this row.
You will see page with columns:
In this page enter new value for password in user_pass column, select MD5 as function and click “Save” link.
Now you can try to login to your WordPress site.
Good luck and don’t forget your password again:)