Reset WordPress password from the command line

Deprecated: mb_convert_encoding(): Handling HTML entities via mbstring is deprecated; use htmlspecialchars, htmlentities, or mb_encode_numericentity/mb_decode_numericentity instead in /var/www/html/wpxss.com/application/wp-content/plugins/wp_glossary/includes/class-wpg-linkify.php on line 316

1. log in to the MySQL:

mysql -u root -p;

2. Select the database:

use database_name;

3. List all users:

select * from wp_users\G

4. Change the password for the user you require:

UPDATE wp_users SET user_pass=MD5('new_password_here') where ID=user_id_here;