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


  • 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

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