Help changing admin password via SequelPro

trellis
1

I have searched online and found this:

UPDATE wp_users
SET user_pass= MD5('root')
WHERE ID = 2

But I get the message “no errors, 0 rows affected.”

Can anyone help with the correct query?

2

Read https://www.cyberciti.biz/faq/mysql-change-user-password/

Don’t forget to backup your DB before running any queries

3

This topic was automatically closed after 42 days. New replies are no longer allowed.