How do I reset my wordpress password via virtuamin webmin database

5 posts / 0 new
Topic locked
Last post
#1 Sat, 02/25/2017 - 21:06
WENGO

How do I reset my wordpress password via virtuamin webmin database

Hi there please I need my password for wordpress restet.

The default methods via email is not working. Usually with cpanel I could do this via php admin

I just need to be able to access my db and change the password I have been able to access the db but cannot change the password

Please help

Thu, 03/02/2017 - 10:29
jonkristian

You can't change the password directly in the db, it hashed ad salted.

What you can do is install wp-cli and call wp user update but that's outside the scope of this forum. If you google it you will surely find a tutorial on how to do that.

Thu, 03/02/2017 - 18:12
OliverF

I will disagree, it CAN be done.

Open your WP database in phpmyadmin.
left column, wp_users
Admin username, click Modify
Third line, user_pass
Right-side column, type your chosen pwd in plain text
middle column, dropdown, choose "MD5"
Execute

Done :)

Thu, 03/02/2017 - 19:40
jonkristian

Cool! I didn't think that would work.
I now see that there's also a way to apply new password via theme functions: wp_set_password( 'password', 1 );

Thu, 03/09/2017 - 02:37
unborn
unborn's picture

i think that this was resolved for him in this https://www.virtualmin.com/node/48632

Configuring/troubleshooting Debian servers is always great fun

Topic locked