Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted June 10, 20177 yr I need to change my login password to a forum account via MySQL. How can I change the users password using MySQL? I don't care if the password is 123456 I just need to change it for now....
June 10, 20177 yr 5 hours ago, Ricardo Rodrigues said: I need to change my login password to a forum account via MySQL. How can I change the users password using MySQL? I don't care if the password is 123456 I just need to change it for now.... Have you tried to use the forgot password link btw? It will allow you to reset it. Anyways, passwords in Ipb are hashed. They are not stored as plain test. You can try to run this query though: UPDATE core_members SET members_pass_hash = '$2a$13$Yg8psuBh3X8coRANYj14NOFltqAUpvpj7tmtKT6XVzpyL6iLKqsR2', members_pass_salt = 'Yg8psuBh3X8coRANYj14Na' WHERE member_id = y; This should reset the password to 123456. Replace y with your actual id number in the query above btw.
Archived
This topic is now archived and is closed to further replies.