• Mysql

Change wordpress user password from CLI

By PrasadNaik

February 18, 2025

If you are not able to login to wordpress admin and want to reset password

Follow below steps

Login to server as root user

Check database name in wp-config.php file

grep DB_NAME wp-config.php

mysql

use DB_NAME;

mysql> show tables;

+————————–+
| Tables_in_onlinesu_wp637 |
+————————–+
| wp_commentmeta |
| wp_comments |
| wp_links |
| wp_options |
| wp_postmeta |
| wp_posts |
| wp_swp_testimonial |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_termmeta |
| wp_terms |
| wp_usermeta |
| wp_users |
+————————–+
13 rows in set (0.01 sec)

select * from wp_users;

Note down the username password you want to reset

and run below command to reset username password

mysql> UPDATE wp_users SET user_pass = MD5(‘Akaomxxx’) WHERE user_login =’username’ ;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0