Sometimes, for whatever reason, we do not have access to the WordPress backend, either because we forget the password or because we inherit the management of the website developed in WordPress from another administrator and we do not know the access credentials, which limits our management. of the same.
Usually, a system must provide a way to change a password, either because the user suspects that the current password has been compromised, or as a precaution. As a user you must ensure that you never use the same password for two or more different services, and it is an important tip that when changing your password you do not use the same one that you used before or in another similar service.
There are several ways to recover said password, leaving aside the traditional Have you lost your password?, and assuming that we have access as administrators to the Hosting Panel (cPanel or the appropriate one). On this occasion we will see how to modify the password through phpmyadmin, working directly on the Wordpress database.
Reset the password from phpMyAdmin
We access the Hosting Panel (cPanel).
From the File Manager in /public_html (or WordPress installation folder) we locate the wp-config.php file.
We edit the wp-config.php file and check which database is in use (if we use several in the Hosting).
From the Hosting Panel we access the phpMyAdmin database manager.
From phpMyAdmin we load the database in use.
We locate the wp_users table.
If there are several users in the user_login column, we locate the user "admin".
We edit said record from the "Edit" option of said record.
In the user_pass row, column "Function" we set the selector to MD5.
In the same row, column "Value" we find the current password encoded in base64.
We select said value and delete it by writing the new value in plain text.
We apply the changes by clicking on "Continue".
We verify from the url of our WordPress that we can access the url http://www.dominio.com/wp-login.php.
