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

  • ssh Too many authentication failures not prompting for password
  • LightDM Mint Ubuntu Debian won't start errors Nvidia Graphics
  • WARNING: Unable to determine the path to install the libglvnd EGL vendor library config files. Check that you have pkg-config and the libglvnd development libraries installed, or specify a path with --glvnd-egl-config-path. Linux Ubuntu Mint Debian E
  • How To Upgrade Linux Mint 18.2 to 18.3 to 19.x and 20.x
  • MP3s Won't Play / ID3 Version 2.4 Issues in Cars and Other MP3 Players/CDs/DVDs Solution
  • LXC Containers LXD How to Install and Configure Tutorial Ubuntu Debian Mint
  • GlusterFS HowTo Tutorial For Distributed Storage in Docker, Kubernetes, LXC, KVM, Proxmox
  • Ubuntu Mint audio output not working pulseaudio "pulseaudio[13710]: [pulseaudio] sink-input.c: Failed to create sink input: too many inputs per sink."
  • How To Shrink Dynamically Allocated VM QEMU KVM VMware Disk Image File
  • How To Enable Linux Swapfile Instead of Partition Ubuntu Mint Debian Centos
  • 404 Not Found [IP: 151.101.194.132 80] apt update Debian 11 Bullseye Solution The repository 'http://security.debian.org bullseye/updates Release' does not have a Release file.
  • WARNING: Can't download daily.cvd from db.local.clamav.net freshclam clamav error solution
  • (firefox:9562): LIBDBUSMENU-GLIB-WARNING **: Unable to get session bus: Failed to execute child process "dbus-launch" (No such file or directory) Solution
  • Debian Mint Ubuntu Which Package Provides missing top, ps and w Solution
  • Vbox Virtualbox DNS NAT Network Mode NOT working
  • Docker Tutorial HowTo Install Docker, Use and Create Docker Container Images Clustering Swarm Mode Monitoring Service Hosting Provider
  • Zoom Password Error 'That passcode was incorrect' - Solution Wrong Passcode Wrong Meeting Name
  • How To Startup and Open Remote/Local Folder/Directory in Ubuntu Linux Mint automatically upon login
  • How To Reset Windows Server Password 2019, 2022, 7, 8, 10, 11 Recovery and Removal Guide Using Linux Ubuntu Mint Debian
  • How To Create OpenVPN Server for Secure Remote Corporate Access in Linux Debian/Mint/Ubuntu with client public key authentication