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

Design copyright www.linuxonlinehelp.com - Linux PC & Server Support