Wordpress Reset Blog User Password from MySQL Using Linux Bash and not PHPMyadmin

 

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";


Tags:

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

  • Linux Mint Dual Boot Install Avoid Wiping our your Main C: drive /dev/sda MBR
  • QEMU-KVM soundhw deprecated how to enable sound in QEMU 4.x series
  • Virtualbox Error Cannot register the hard disk because a hard disk with UUID already exists solution
  • kernel: [549267.368859] mate-terminal[7871]: segfault at 2000000101 ip 00007f5d0a9548f0 sp 00007fff7012c610 error 4 in libgobject-2.0.so.0.4800.2[7f5d0a920000+52000]
  • apcupsd how to setup and monitor APC UPS units
  • How To Password Reset, Recover, Bypass, Remove and Unlock on Windows 10,8,7,Vista,XP,NT,2000,2003,2008,2012,2016,2019 Administrative Login Programs
  • Nvidia Ubuntu Linux Screentearing Video with solution driver
  • ?? Question Marks for time, permissions and size of a file?
  • mdadm how to stop a check
  • access denied by acl file qemu-kvm: bridge helper failed
  • Linux NIC connecting at 100M instead of 1000M gigabit speeds? It could be overheating
  • "This kernel requires the following features not present on the CPU: cmov Unable to boot - please use a kernel appropriate for your CPU.
  • http://vault.centos.org/5.9/os/i386/repodata/filelists.xml.gz: [Errno -1] Metadata file does not match checksum solution
  • Linux Ubuntu Wifi Disabled Only Works When Laptop Plugged Into Wall AC Power
  • CentOS 6 impossible to compile a newer libguestfs
  • chroot
  • How To Get Started on Ubuntu with gpt-2 OpenAI Text Prediction
  • Remove cloud-init in your VM
  • QEMU-KVM KVM Command Line Practical Guide
  • Linux How To Change NIC Name to eth0 instead of enps33 or enp0s25