You can reset the password of a WordPress user by executing the following steps.
Step 1 : Login to MySQL console from SSH.
You can get these details from the “wp-config.php” file of your WordPress Site.
Step 2 : Access the corresponding database.
Step 3 : Get the user ID from the table “wp_users”. Please replace “WP_USERNAME” with the correct username.
Step 4 : As you can see “1” is the IP of the username. Now you can update the password using the following query.
Step 5 : All done, now you can access the WP Dashboard using the new credentials.