There can be some reasons you need to reset the password in WordPress. If your website is sometimes exposed to the breaking or somebody can’t become authorized in system for any of several reasons then the only way to correct everything will be the password resetting.
Stage 1: be connected to the WordPress database by means of phpMyAdmin!
You need to become authorized in cPanel giving by your hoster to be connected in the WP database by means of phpMyAdmin. Scroll the page down to the section of database and click on an icon of phpMyAdmin, which is allocated on a mentioned below screenshot.
Stage 2: choose the WordPress database and the table „Users”!
Authorizing in the control panel, choose the WP database from the list of bases giving on the left side of the phpMyAdmin web interface. If you have some databases, and you aren't sure what of them you need, you can learn the database name by means of the file wp-config.php. The wp-config.php file can be found in the systemroot WP, and the name of a database can be seen in line: define ('DB_NAME', 'YOUR_DATABASE_NAME');
A list of tables appears before you after pressing on the WordPress database. If you didn't change a prefix of tables, all names of tables will start with wp_.
Click on the table wp_users and then on the Browse tab („overview” is highlighted on a screenshot below) to look through content of this table, for example, the list of users and their adjustments.
If your base has only one user, the table consists of one line, as is shown in a screenshot.
Stage 3: resetting of the password of WordPress!
Click on the button “Edit“ to edit the user of WordPress by means of phpMyAdmin, for example, to change the password (edit — it’s shown in the form of a pencil).
As can be seen from a mentioned below screenshot, you can edit any user data. The password of the user is stored in the encrypted form (MD5) and represents a casual symbol set in the column «user_pass», as is shown in a mentioned below screenshot. It is necessary for safety.
You can simply start to enter the new password in the field „value” in the column „user_pass”. As soon as you point a new password (Pass123 is used in a mentioned below example!) choose MD5 in the dropping menu of the column „Function” to store also the password in the encrypted form.
Click on the button „GO” to keep the new password. We congratulate! You have just reset the user’s password in WordPress by means of phpMyAdmin.