How to Reset WordPress Password Using MySQL Command Prompt

By WP Saviour •  Updated: 03/02/21 •  5 min read

Our WordPress Password Restoration assortment is sorted in accordance with the popularity of the tutorial talked about. For starters, you’ll have have probably the most well-liked restoration chance – i.e. using phpMyAdmin. There are particular webhosting suppliers who do not current cPanel and/or phpMyAdmin. What do you do then? Study this textual content to be taught to reset wordPress password using MySQL command fast!


Rest assured, since WordPress used one database – (usually MySQL), every web internet hosting provider ought to have a Database Administration System increased typically referred to as DBMS. On this tutorial, we’ll be using the MySQL command fast (abbreviated as CMD) which is a free DBMS as licensed beneath GNU Fundamental Public License v2.


Recovering your password using the MySQL CMD consists of lesser number of steps and could possibly be considered an widespread password restoration system; inside the sense that it might be utilized in just about any plausible state of affairs.

Nonetheless,  it is good to have a working understanding of databases and the best way WordPress interacts with one. Apart from that, you moreover should know the subsequent technical options:

Logging in to the MySQL Command Instant

Residence home windows

Whenever you’re working an offline arrange of WordPress in Residence home windows using WAMP or XAMPP, then to launch the MySQL CMD, click on on on the WAMP icon > MySQL > MySQL console. This straight logs you in. There’s no should enter any further directions. Head over to the following step.



Most shared web internet hosting suppliers, VPS, devoted servers use a variant of Linux which embody CentOS, Debian, Fedora or Ubuntu to name just some.

In the event you’re working an offline arrange of WordPress in Linux using LAMP, then merely launch terminal emulator and type the command:

mysql -u root -p

Whenever you’re trying to reset the password in a distant server, hook up with it by the use of SSH using any SSH client – as an example, the world’s favorite client – Putty. After you have got logged in to the distant server, to login to MySQL, use the subsequent command:

mysql -u root -p <password>


Resetting the WordPress Password:

Now that you’ve entry to the MySQL CMD indicated by the “mysql >” fast, its time to work the magic. Properly, not magic – merely good ol’ MySQL directions. ?




Enter the subsequent directions ditto:

use wp_genesis;
SELECT ID, user_login, user_pass FROM wp_users;
UPDATE wp_users SET user_pass = MD5(‘WPSAViouR’) WHERE ID=1 LIMIT 1;

In case the ultimate command does not go in accordance with the screenshot, delete the the one quotes and manually type them inside the CMD. That must do the trick.


It’ll reset the password of the admin client to WPSAVIOUR. In reality, whereas setting a model new password, you’ll must make use of a stronger one. As quickly as accomplished, you’ll exit the MySQL CMD by using the command:


Video Tutorial

Proper right here’s a video tutorial describing all of the course of. I might advocate learning the article first, nonetheless do you have to’re looking out for a quick restore, that’s your queue:



In conclusion to our WordPress Password Restoration assortment I’d want to remind you that half (a) is easier because of 90% of the web internet hosting corporations embrace phpMyAdmin. Nonetheless if in case you have got some free time, I’d advocate trying out this half (using MySQL) as a result of it’ll give you some experience in coping with MySQL directions and databases. And who’s conscious of – probably it’ll be of some use ultimately!

Prevention is greatest than The treatment


I started this assortment off by saying how password saving/backup suppliers like LastPass thrive. Don’t get me incorrect – it wasn’t my intention to return all through as demeaning. I really love and use LastPass regularly. I’ve it put in in my cellphone and in every browser in all my laptop methods. Life (for me) would come to a stand-still with out it.  Really, I can’t survive with out it.

gp-3877166 as-7877031

WP Saviour

I am a WordPress specialist. My mission is to help you create beautiful websites with ease!

By WP Saviour •  Updated:  •  0 min read

WP Saviour

I am a WordPress specialist. My mission is to help you create beautiful websites with ease!