The reason we use the command below is because we need the md5sum value hash of the password.  This means that we cannot use the md5sum

Change "yournewpass" to the pass you want to set

echo -n "yournewpass" | md5sum

Then you get the md5sum hash of whatever you entered eg. in this case "yournewpass"


5a9351ed00c7d484486c571e7a78c913  -

*Do not copy the " - " part just the md5sum sequence:

5a9351ed00c7d484486c571e7a78c913

If you don't mind your pass being set to "yournewpass" you could just copy the md5 hash as shown above and insert into the MySQL query further on below.

Copy the output above "5a9351ed00c7d484486c571e7a78c913"

Use MySQL To Change Your Password

You can connect with the root/admin user or just the user of your Wordpress database.

yourwordpressdbuser = The MySQL Database User for your Wordpress

yourwordpressdbname = The database name that you use for your Wordpress

5a9351ed00c7d484486c571e7a78c913 = The md5sum hash equivalent of "yournewpass"

mysql -u yourwordpressdbuser -p

use yourwordpressdbname;

UPDATE wp_users SET user_pass= "5a9351ed00c7d484486c571e7a78c913" WHERE user_login = "yourwordpressusername";

wordpress, reset, blog, user, password, mysql, linux, bash, phpmyadminchange, quot, yournewpass, echo, md, sum, output, yourwordpressdbuser, yourwordpressdbname, update, wp_users, user_pass, user_login, yourwordpressusername,

Latest Articles