WordPress: Change User Password manual on mysql prompt

If you don’t want to use Passwords generated by wordpress itself, you can do it manual on a MYSQL Console

howto:

  • Login to your Webserver with the Database via encrypted SSH!!
  • Login to the MYSQL Server Conssole with
$ mysql -u username -p
  • Enter Password, and change database with
mysql>use database-name-of-blog
  • Now Set Password for the User
mysql>UPDATE wp_users SET user_pass = MD5('NEWPASSWORD-16-DIGITS') WHERE user_login = "THEUSERNAME";
  • System shows Echo:
mysql> ok.. Changed 1 Row..
  • Quit
mysql> exit
  • Logout of SSH
Impressum Datenschutz-DSGVO-GDPR

www.linuxonlinehelp.eu - Linux PC & Server Support since 2004 Tags: Linux Online Help, Linuxonlinehelp, Linux Support, Linux Hilfe