Roots Discourse

Help changing admin password via SequelPro

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?

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

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